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.