Refresh a PivotTable list with updated source data
- In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
- On the 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.