Refresh a PivotTable list with updated source data
- Click the PivotTable list.
- On the PivotTable list toolbar, click Refresh .
- 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.