Microsoft Office Tutorials and References
In Depth Information
Refresh PivotTable Data
Chapter 6: Analyzing Data with PivotTables
The PivotTable Options
dialog box appears.
5 Click the Data tab.
6 Click to select the Refresh
Data When Opening the
7 Click OK.
Excel applies the refresh
If your PivotTable is based on external data,
you can set up a schedule that automatically
refreshes the PivotTable at a specified interval.
Click any cell inside the PivotTable, click the
Options tab, click the Refresh drop-down arrow,
and then click Connection Properties. Select the
Refresh Every check box, and then use the spin
box to specify the refresh interval, in minutes.
If you set up an automatic refresh,
you might prefer not to have the
source data updated too frequently.
Depending on where the data
resides and how much data you are
working with, the refresh could take
some time, which may slow down
the rest of your work.