Refresh a PivotTable list with updated source data
- Click the PivotTable list.
- On the PivotTable list toolbar, click Refresh .
Notes
- The Office logo cube stops spinning when the refresh operation is complete. While the PivotTable list is being refreshed, you cannot interact with it or make changes to it.
-
To cancel a refresh operation, press ESC. You can cancel the refresh operation only when the PivotTable list is being calculated
— not while source data is being retrieved.