Excel Refresh Pivot Table After Query Refresh: How It Works

Charts & pivot tables · Updated November 19, 2026

To refresh a PivotTable after its query has finished updating, select a cell in the PivotTable and choose PivotTable Analyze > Refresh, or right-click the PivotTable and choose Refresh. You can also use Data > Refresh All to refresh workbook connections and PivotTables; if the result still looks old, refresh the query first, wait for it to finish, and then refresh the PivotTable.

Why a query refresh may not update a PivotTable

A query and a PivotTable are separate parts of the workbook. A query—often created with Power Query—imports, combines, or transforms data. The PivotTable then summarizes data from a source, such as the query’s output table, the workbook Data Model, or an external connection. Refreshing one part does not always mean the other part has already finished updating.

For example, a query might change a worksheet table from 500 sales records to 520 records. The PivotTable can continue showing the previous totals until its pivot cache or model data is refreshed. The pivot cache is the PivotTable’s stored copy of source data; it is not necessarily updated at the exact moment the query starts refreshing.

Timing also matters. Some connections can refresh in the background, so Excel returns control while a query is still running. If the PivotTable refreshes before the query has completed, it may read the previous results. This is one reason a second PivotTable refresh can appear to fix the problem.

The reliable refresh sequence

For a predictable manual update in Excel for Microsoft 365 on Windows, refresh the query, confirm that it has completed, and then refresh the PivotTable. This is especially useful when you have a large query, background refresh enabled, or a workbook where the PivotTable source depends on query output.

  1. On the Data tab, choose Queries & Connections to open the pane and locate the query. You can also use Data > Refresh All when you want to refresh all workbook data connections.
  2. If refreshing a single query, right-click it in the Queries & Connections pane and choose Refresh. Wait for the refresh to finish; check the pane or Excel’s status information rather than immediately moving to the next step.
  3. Check the query output. If it loads to a worksheet table, confirm that the table contains the updated rows or values. If the query loads only to the Data Model, use a PivotTable connected to that model and ensure the model refresh has completed.
  4. Click inside the PivotTable and choose PivotTable Analyze > Refresh. Alternatively, right-click inside the PivotTable and choose Refresh.
  5. Check the totals, row labels, and any filters. A filter or slicer can hide newly added records even when the pivot itself refreshed successfully.

If you have several PivotTables and connections, Data > Refresh All is the convenient first choice. For a workbook where refresh order is critical, the sequential method above makes it easier to confirm that the query is done before the pivot reads its results.

What Refresh All does—and when to refresh separately

Data > Refresh All is intended to refresh the workbook’s data connections and related reports, including PivotTables. It is usually the simplest option when a workbook has a straightforward query-to-table-to-pivot setup. It can save time compared with refreshing each item separately.

However, Refresh All is not a guarantee that every source has finished before every dependent report updates. Background refresh and connection behavior can affect timing, and refreshes can fail for reasons such as credentials, unavailable files, or blocked network access. If the pivot remains stale, refresh the query by itself, wait for completion, and then refresh the PivotTable. This separates a query problem from a PivotTable problem.

Refreshing only the PivotTable is appropriate when its source data has already changed and is available. Refreshing only the query is appropriate when you want to update the query output but do not need the summary yet. If the query feeds several pivots, refreshing the query first and then using Refresh All is a practical way to update the reports after confirming the source is ready.

Make sure the PivotTable uses the right source

A refresh can only summarize the data that the PivotTable is configured to use. If a pivot was created from a fixed worksheet range, such as A1:F500, records added below row 500 may not be included. The query can successfully load 520 rows while the PivotTable continues to summarize only the original 500.

When possible, load query results to an Excel table and base the PivotTable on that table. Excel tables expand as rows are added, which makes them a more reliable source than a manually selected fixed range. To inspect or change a worksheet-based PivotTable’s source, click inside it and look for PivotTable Analyze > Change Data Source. The exact available options depend on how the pivot was created.

For a table-based source, confirm that the query is loading to the expected table and that the PivotTable source points to that table. For a Data Model PivotTable, the data comes from the model rather than a worksheet range, so changing a normal range is not the fix. Refresh the relevant connection or model and then refresh the PivotTable.

Common causes of stale or missing results

  • The query is still running. Wait for completion before refreshing the PivotTable, particularly when background refresh is enabled.
  • The source range is fixed. New records fall outside the pivot’s selected source. Use an Excel table or update the source range.
  • The query loaded somewhere else. Verify the query’s load destination and make sure the PivotTable uses that output or the correct Data Model.
  • A filter hides the new data. Check report filters, row and column filters, slicers, and timelines. A record can be present in the source but absent from the displayed summary because of a filter.
  • The query did not actually refresh. Look for an error in Queries & Connections, a credentials prompt, a missing file, or a connection problem. Refreshing the pivot cannot repair a failed source query.
  • The PivotTable has not recalculated its displayed summary. Click inside it and run Refresh after confirming that the source data is current.

For a quick diagnosis, compare a known value in the query output with the PivotTable result. If the output itself is old, investigate the query or its source. If the output is current but the pivot is not, inspect the pivot source, refresh the pivot, and check filters.

Background refresh and refresh-on-open settings

Some workbook connections can run in the background. That can make a refresh feel faster because you can continue working, but it can complicate dependent steps: the PivotTable may be refreshed while the query is still retrieving or transforming data. If the workbook repeatedly shows stale pivot results after Refresh All, review the connection’s refresh options and consider disabling background refresh where that option is available.

In Excel for Windows, select Data > Queries & Connections, right-click the relevant connection or query, and inspect its properties. Available controls depend on the connection type. If you change a background-refresh option, save the workbook and test the normal refresh process. Disabling background refresh can make Excel wait for a connection, but it may also mean the workbook appears busy for longer.

You can also configure a connection to refresh when the workbook opens, where its properties offer that setting. That does not necessarily mean a PivotTable will be ready the instant the workbook opens: the query may need time, a network connection, or credentials. If users need current figures before making decisions, have them confirm that refresh completed and that the PivotTable shows the expected data.

Excel for Mac and Excel for the web

In Excel for Mac, the general approach is the same: refresh the query or connection, wait for it to complete, and then refresh the PivotTable. Use the available commands on the Data and PivotTable Analyze tabs, or right-click the PivotTable and choose its refresh command. Ribbon labels and the availability of particular connection-property controls can vary by Excel version and connection type.

Excel for the web has different data-connection and Power Query capabilities from the Windows desktop app, and not every workbook connection can be refreshed there. If the workbook’s query cannot be refreshed in the browser, open it in Excel for Microsoft 365 on Windows or Mac and refresh it in the desktop app. A PivotTable refresh in the browser cannot display newly queried data if the query itself has not updated the workbook’s source.

Frequently Asked Questions

Does Refresh All refresh PivotTables after Power Query?
Refresh All is designed to refresh workbook data connections and PivotTables. If a pivot still shows old results, refresh the query, wait until it finishes, and then refresh the PivotTable separately; background refresh or a failed connection may affect the result.

How do I refresh a PivotTable without refreshing the query?
Click inside the PivotTable and choose PivotTable Analyze > Refresh, or right-click it and choose Refresh. This updates the pivot from its available source; it does not retrieve new data from a query that has not been refreshed.

Why does my PivotTable not include new rows from a query?
Check that the query output includes the rows and that the PivotTable source covers them. A fixed cell range can exclude added records. Loading to an Excel table and using that table as the source helps the pivot include rows added by later query refreshes.

Can I make a PivotTable refresh automatically after Power Query?
Refresh All can update connections and PivotTables together, and connection settings may offer refresh-on-open behavior. For a dependable sequence when timing is an issue, refresh the query first and the PivotTable second. Excel’s built-in settings may not provide the same controlled sequence for every connection and workbook design.

Why does Refresh All work only after I click Refresh again?
The query may be running in the background, so the first pivot refresh can use the previous output. Wait for the query to finish and refresh the pivot again. If this happens regularly, review background-refresh settings and check for connection errors or an incorrect PivotTable source.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.