Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web
  1. Select anywhere in the PivotTable.

  2. On the PivotTable Analyze tab, select Refresh PivotTable button Refresh.

Select the down arrow on the Refresh PivotTable button Refresh button for additional refresh options. 

For more info, see Overview of PivotTables and PivotCharts.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.