Excel Pivot Table Refresh All Not Working? Try These Fixes

Charts & pivot tables · Updated November 19, 2026

If Excel’s Refresh All command is not updating a PivotTable, first check whether the PivotTable’s source includes the new or changed data. In Microsoft 365 for Windows, choose Data > Refresh All; if the source is a fixed cell range, expand it through PivotTable Analyze > Change Data Source, then refresh again. Refresh All cannot bring in rows that fall outside a PivotTable’s source.

What Refresh All actually refreshes

A PivotTable displays a summarized view of source data, rather than continuously recalculating its visible results as the source changes. Refreshing tells Excel to retrieve or recalculate the data used by the PivotTable. Refresh All is broader: it asks Excel to refresh the workbook’s refreshable data connections and PivotTables. Depending on how the workbook is built, that can include a Power Query query, an external data connection, a linked table, and one or more PivotTables.

That does not mean every workbook component updates in the same way. A query may fail or be unavailable, a connection may be set not to refresh, or a PivotTable may point to a different source than the query you just refreshed. A refresh can also complete without an obvious error while the displayed report still looks unchanged—for example, because a filter hides the new item. The important first step is to identify the whole path: where the source data comes from, whether that source refreshed, and which range or model the PivotTable summarizes.

Check whether the source data is included

The most common cause is a source range that stops before the new rows. For example, a PivotTable built from A1:D500 will not include a record entered on row 501 just because you choose Refresh All. In Excel for Windows, click inside the PivotTable and select PivotTable Analyze > Change Data Source to see or change its source. Check both the first and last row and make sure all required columns are included.

For a source that grows over time, convert the source range to an Excel Table. Select a cell in the source and choose Insert > Table, confirming that the header row is identified correctly. When you add records directly below a Table, Excel normally expands the Table to include them. Then set the PivotTable’s source to that Table, rather than a fixed address. A Table reduces the chance that next month’s rows will be left outside the range, but the PivotTable still needs a refresh to show the new records.

  • Confirm the new records are in the same worksheet and source Table or range the PivotTable uses.
  • Check for blank header cells, duplicate or changed column names, and an accidentally omitted field.
  • If a PivotTable is built from the Data Model or another connection, do not assume Change Data Source can replace its model. Update the relevant query, connection, or model instead.

Refresh the PivotTable separately

Refresh All is convenient, but refreshing one PivotTable can help determine whether the problem is with that report or with a workbook-wide connection. Click inside the PivotTable and choose PivotTable Analyze > Refresh. You can also right-click inside the PivotTable and choose Refresh. If this works but Refresh All does not, inspect the workbook’s other connections and queries; a stalled or failed connection may be involved.

On Windows, Ctrl+Alt+F5 is the keyboard shortcut for Refresh All. Ctrl+Alt+F5 asks Excel to refresh workbook data, while the PivotTable’s individual Refresh command targets the selected report. On a Mac, use Data > Refresh All or the PivotTable’s Refresh command; keyboard shortcuts can differ by keyboard and Excel version, so the menu is the reliable route. If more than one PivotTable uses the same source, refresh each relevant report or use Refresh All after confirming the source is ready.

Find out whether a query or connection failed

If a workbook uses Power Query or external data, check whether the input itself updated. In Windows Excel, choose Data > Queries & Connections to open the pane. Review the query or connection for an error, an old refresh time, or a status suggesting that it is still refreshing. You can right-click an individual query and choose Refresh to isolate it. If the query fails, refreshing its PivotTable will not repair the upstream problem.

For an external source, confirm that the file, database, server, or network location is reachable and that you have permission to access it. A password may have expired, a file may have moved, or the computer may be offline or disconnected from a company network. Some data sources also require a sign-in or a supported connection method. Resolve the source issue, refresh the query or connection, and then refresh the PivotTable that uses its output.

Background refresh can make it appear that Excel ignored the command: Excel may return control while a connection is still working. Check the status shown in Excel and allow the refresh to finish before judging the PivotTable. For supported connections, the connection’s properties may include an option to enable or disable background refresh. In Excel for Windows, inspect the connection through Data > Queries & Connections, then its Properties, when that option is available. The exact options depend on the connection type.

Look for filters, grouping, and calculation issues

Sometimes the data refreshed, but the report still shows the same visible totals. Open the PivotTable field filters and check whether the new category, date, or item is excluded. A report filter, slicer, timeline, or manually selected item can hide records without producing an error. Clear the relevant filter temporarily and see whether the expected item appears. Also check whether the PivotTable is grouped by month or year: a new date may be included in an existing group rather than displayed as a separate label.

Check the source values as well as the PivotTable. If a source column contains numbers stored as text, blanks, or inconsistent labels such as East and east, the PivotTable may summarize or group the records in an unexpected way. A field set to Count rather than Sum can make numeric-looking results seem wrong. Right-click a value in the PivotTable, choose Summarize Values By, and verify the intended calculation. If the source contains formulas and Excel’s calculation mode is Manual, recalculate the workbook before refreshing so the PivotTable reads current formula results. On Windows, Formulas > Calculation Options shows the calculation mode.

Resolve cached data and field changes

PivotTables use a cache or model to organize the data they summarize. Refreshing updates that stored view from its source, but it does not correct a mismatch in the source structure. If a source column was renamed or removed, the PivotTable may show an error, retain an old field, or need its layout repaired. Check that the source still has valid, unique column headers and that the fields used in Rows, Columns, Values, and Filters still exist.

When a refresh appears successful but old items remain in a field dropdown, those items may be retained in the PivotTable’s cache. For a conventional PivotTable, click inside it and open PivotTable Analyze > Options; in the PivotTable Options dialog, look for the Data tab and the setting for retaining items deleted from the data source. The wording or availability can vary by Excel build and PivotTable type. Setting retention to None and refreshing can remove old field items, but it does not add missing source rows or fix a wrong source range.

PivotTables connected to the Data Model, Power Pivot, or an OLAP source have different refresh and field-management behavior from a simple range-based PivotTable. For those reports, first refresh the query or model that supplies the data, then refresh the report. Some changes to a model’s columns or measures require changes in the model itself, not just another PivotTable refresh.

Check refresh settings and workbook limitations

A workbook may be configured so a connection does not refresh automatically, or it may require a prompt before accessing external data. If the file opens with a security warning, blocked external content, or a request to enable connections, follow your organization’s security policy and confirm that the source is trusted before allowing access. Do not enable an unknown connection simply to make a refresh succeed.

For a connection that should update when the file opens, review its properties and look for a refresh-on-open setting, if that setting is offered for the connection type. This affects opening the workbook; it is not a substitute for fixing a broken source or a PivotTable that points to the wrong data. If the workbook is shared, confirm that you are editing the current file rather than a downloaded copy, an older version, or a read-only copy. A successful refresh in one copy will not update another workbook saved elsewhere.

Excel for Mac and Excel for the web

In Excel for Mac, the main troubleshooting principles are the same: confirm the source, use Data > Refresh All, and refresh an individual PivotTable from its controls. Ribbon labels and connection settings can differ from Windows, and some Windows-specific data connection or model features may not be available in the same way. If the workbook depends on a Windows-only connection or Power Pivot feature, open it in desktop Excel for Windows to inspect and refresh that component.

Excel for the web can refresh some PivotTables and supported workbook data, but not every external connection or feature can be refreshed there. Availability depends on the source and workbook configuration. If a refresh control is missing, disabled, or cannot access the source, open the workbook in the desktop app and use the connection’s supported refresh process. Avoid assuming that a workbook’s visible values are current merely because it opened successfully in a browser.

A reliable troubleshooting sequence

Work through these checks in order so you can identify whether the failure is in the source, connection, or PivotTable rather than repeatedly clicking Refresh All:

  1. Save a copy of the workbook if it is important, then confirm you have the latest editable file.
  2. Inspect the source data and confirm the new rows are inside the source Table or PivotTable range.
  3. Refresh the relevant query or external connection, if the workbook uses one, and resolve any sign-in, network, or source error.
  4. Click inside the PivotTable and choose PivotTable Analyze > Refresh. Check the visible results and filters.
  5. If the individual refresh works, choose Data > Refresh All and watch for connection status or error messages.
  6. If the results still look wrong, verify field names, value summarization, date grouping, filters, and formula calculation mode.

This order also helps distinguish a genuine refresh failure from a reporting issue. For instance, if the source table contains a new order, the query output contains it, and the PivotTable source includes it, but the total remains unchanged, inspect filters and the Values calculation. If the query output itself is old, focus on the query or connection before changing the PivotTable layout.

Frequently Asked Questions

Why does Refresh All not include new rows in my PivotTable?
Most often, the PivotTable uses a fixed source range that ends before those rows. Expand the source through PivotTable Analyze > Change Data Source, or use an Excel Table as the source so it can grow with added records. Refresh again after confirming the records are included.

Does Refresh All refresh every PivotTable in a workbook?
It requests refreshes for workbook PivotTables and refreshable data connections, but a connection can fail, be unavailable, or require separate attention. Check Data > Queries & Connections and refresh a specific PivotTable to narrow down what did not update.

Why does my PivotTable refresh but show the old total?
The new records may be filtered out, the source formulas may not have recalculated, or the Values field may be using Count instead of Sum. Check the report filters, source values, calculation mode, and the field’s Summarize Values By setting.

Can I refresh a PivotTable in Excel for the web?
Some PivotTables and sources can be refreshed in the browser, but support depends on the workbook and connection type. If the refresh option is unavailable or the external source cannot be reached, use desktop Excel with a supported connection.

How do I make a PivotTable refresh when I open the file?
For supported connections, inspect the connection properties for a refresh-on-open option. The setting is not available for every source, and it will not fix a bad source range, missing credentials, or a connection that cannot be reached.

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.