Excel Guides

Refreshing PivotTable Data in Excel

To refresh data in a PivotTable, follow these steps:

  1. Click any cell in the PivotTable report.
  2. On the PivotTable tab, in the Data group, click Refresh. - Note: If the PivotTable is connected to an external data source, you can also click Refresh Data.
What Happens When You Refresh Data in a PivotTable Report?
When you refresh data in a PivotTable report, Excel re-queries the data source and gets the latest data. If the data source is a cell range of worksheet data, or if you're using an Excel table as your data source, any new rows or columns that were added to the end of the data range are included in the refreshed PivotTable report. If rows or columns were inserted within the data range, or if cells outside of the data range were changed, those changes are not reflected in a refreshed PivotTable report.
How to Refresh Data when Using an External Data Source
If your PivotTable report is based on an external data source, such as a SQL Server database, Access database or cube, you can set up a connection and schedule it to refresh automatically. For more information about how to do this, see one of these articles:
How to Refresh Data when Not Using an External Data Source
If your PivotTable report is not based on an external data source , but instead uses worksheet data or an Excel table , you can still set it up to refresh automatically . For more information about how to do this , see Schedule automatic updates for a Pivot Table report .

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.