Refresh PivotTable data

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

Some of the content in this topic may not be applicable to some languages.

When a PivotTable report is connected to another PivotTable in the same workbook or in another workbook, or to an external data source, you can perform a refresh operation to retrieve any data updates. Each time you refresh the PivotTable data, you’ll see the most recent version of the data, including changes that were made to the data since it was last refreshed.

By default, PivotTables are not refreshed automatically, but you can specify that the PivotTable is automatically refreshed when you open the workbook that contains the PivotTable.

Do any of the following:

Refresh PivotTable data manually

  1. On the PivotTable tab, under Data, click the arrow next to Refresh.

  2. To update the information to match the data source for the current PivotTable, click Refresh. To refresh all the PivotTables in the workbook, click Refresh All.

Refresh PivotTable data automatically when you open the workbook

  1. On the PivotTable tab, under Data, click Options.

  2. In the PivotTable Options dialog box, click Data.

  3. Click Refresh data when opening file.

See also

Get support
Contact us
Expand your Office skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.