PivotTable Not Showing Up-to-Date Data After Refresh / Refresh All

Hi, DataAnalyst

It looks like the query is updating, but the PivotTable is still hanging on to an older view, either because File A has not fully saved/synced yet, or because the Pivot field cache/filter state is not rebuilding cleanly.

Besides the solutions provided by the Q&A Assist, here are some suggestions you can try:

First, save File A before refreshing File B, and if the files are on OneDrive or SharePoint, let the sync finish first. It is recommended that you make sure AutoSave is on as well, because cloud files can lag behind if changes have not fully synced yet.

Next, clear the Business Date filter completely, then remove that date field from the Pivot and add it back. If the old dates still stick around, open PivotTable Options > Data and set Number of items to retain per field to None, then refresh again.

If Queries & Connections looks current but the Pivot still stays stale, it is recommended that you change the query to Only Create Connection and then load it back to the Pivot again, because the loaded object can sometimes become detached from the query.

Thank you for your patience in reading, I hope this information has been helpful to you. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment."    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

So I just came here with a similar problem. In my case I noticed that the PivotTable was updating immediately when "Refresh All" was clicked, based on the data from the last "Refresh All", instead of waiting for "Queries & Connections" to finish. The PivotTable was one "snapshot" behind due to this.

You can right click the PivotTable after "Queries & Connections" is done and refresh just the PivotTable, or just brute force the whole thing by clicking Refresh All again.

The real solution should be for Excel to fetch all external data first and after the connections finish it should refresh internal sheets/tables/etc, so that they reflect the new data. It's currently doing things in the wrong order.

The PivotTable is not updating because it is based on an external data connection / Data Model query, not directly on the table in File A, and only the query/cache is being refreshed—not necessarily the PivotTable itself or the Data Model behind it.

Key points and checks:

1. Refresh the query and the PivotTable, not just one
   • When using Get & Transform (Power Query) and Load To > PivotTable Report, Excel typically:
     • Loads data into the Data Model or a connection, and
     • Builds the PivotTable on that external connection, not directly on the source table.
   • Refreshing in Queries & Connections updates the Power Query cache and/or Data Model, but the PivotTable must also be refreshed to pull the updated data.
   • In File B:
     1. Click inside the PivotTable.
     2. Go to PivotTable Analyze tab.
     3. Click Refresh (or Refresh → Refresh All to update all PivotTables in the workbook).
2. Understand Power Query caching vs. worksheet/Data Model refresh
   • Power Query keeps a local cache of external data and does not automatically refresh it to avoid unnecessary costs or delays.
   • Refreshing in Power Query Editor (Refresh Preview) only updates the preview/cache, not the worksheet or Data Model:
     • In Power Query Editor, Home > Refresh Preview updates the preview only.
     • To update the worksheet/Data Model, refresh from the Excel worksheet (Query tab or Data tab) or from Power Pivot if the data is in the Data Model.
3. Refresh the query in the worksheet (File B)
   If the query is loaded to a worksheet table as well as a PivotTable:
   1. Select a cell in the query table (in File B).
   2. On the Query tab, select Refresh > Refresh.
      This refreshes both the worksheet data and the Power Query cache from the external source.
4. If the PivotTable is based on a Data Model (Power Pivot)
   When the PivotTable is built from the Data Model:
   1. In File B, go to Power Pivot > Manage.
   2. In the Power Pivot window, select Home > Get External Data > Refresh or Refresh All to refresh the Data Model tables.
   3. Check the refresh status (Success/Error/Cancelled) for each connection.
   4. After that, refresh the PivotTable again from PivotTable Analyze > Refresh.
5. Check connection properties and Refresh All behavior
   • If Refresh All is used, a connection can be configured not to refresh:
     1. In File B, go to Data > Connections.
     2. Select the connection used by the PivotTable and click Properties.
     3. On the Usage tab, under Refresh control, ensure Refresh this connection on Refresh All is checked.
   • If this is unchecked, Refresh All will not update that connection, so the PivotTable will continue to show old data.
6. Confirm the query actually reads the updated table in File A
   • If File A’s table name, sheet, or structure changed, the query may be failing or reading a different range.
   • In File B:
     1. Open Power Pivot > Manage or Data > Queries & Connections.
     2. Edit the query and verify the Source step still points to the correct table in File A.
   • If refresh errors occur, they will show in the refresh status (Error/Cancelled) in Power Pivot or in the External Data Refresh Status dialog.
7. Control refresh timing and background refresh
   • For large data sets, background refresh may delay visible updates:
     1. Click a cell in the connected data.
     2. Go to Data > Refresh All > Connection Properties.
     3. On Usage, review Enable background refresh and other refresh options.
   • If background refresh is enabled, ensure the refresh has completed (check status bar or External Data Refresh Status) before checking the PivotTable.

In summary, ensure that:

• The external connection/Data Model is refreshed (via Data/Query/Power Pivot), and
• The PivotTable itself is refreshed afterward, and
• The connection is allowed to refresh on Refresh All and still points to the correct table in File A.

References:

• Refresh PivotTable data
• Refresh an external data connection in Excel