-
Select anywhere in the PivotTable.
-
On the PivotTable Analyze tab, select
Refresh.
Select the down arrow on the
For more info, see Overview of PivotTables and PivotCharts.
-
Select anywhere in the PivotTable to show PivotTable Analyze in the ribbon.
-
Select
Refresh.
-
Select anywhere in the PivotTable and go to the PivotTable tab.
-
Select the down arrow by
Refresh All and choose Refresh or Refresh All