Excel Pivot Table Refresh Failed? Fix the Common Causes

Charts & pivot tables · Updated November 19, 2026

If an Excel PivotTable refresh failed, first confirm that its source data is available and has a valid, complete header row, then select the PivotTable and choose PivotTable Analyze > Refresh. If that does not work, check the source range or connection, workbook permissions, and any error message; the right fix depends on whether the PivotTable uses a worksheet range, an Excel table, or an external data source.

What refreshing a PivotTable does

A PivotTable summarizes source data, but it does not necessarily update its summary the moment the underlying cells change. Refreshing tells Excel to read the source again and recalculate the displayed totals, categories, and other summaries. A PivotTable may therefore show old figures even though the source worksheet already contains new rows or corrected values.

On Microsoft 365 for Windows, click inside the PivotTable and use PivotTable Analyze > Refresh. You can also right-click a PivotTable cell and select Refresh. To update all eligible connections and PivotTables in the workbook, choose Data > Refresh All. The Windows shortcuts are Alt+F5 for the selected PivotTable and Ctrl+Alt+F5 for Refresh All. On a Mac, use the ribbon or the PivotTable context menu; Windows Alt-based shortcuts may not apply.

Refreshing can fail outright, but it can also appear to succeed while leaving a problem unresolved. For example, Excel might refresh a PivotTable from an old, fixed source range that does not include newly added rows. In that case, the refresh itself may complete, yet the latest records will still be absent.

Check the source data and field names

Start with the source, especially if Excel displays a message such as The PivotTable field name is not valid. A conventional worksheet source needs a single row of unique, nonblank column headings. Each column should contain one field, and the rows below should be records. Blank header cells, duplicate headings, a heading merged across cells, or a title row included above the actual headers can prevent Excel from reading the source correctly.

Inspect the source for structural changes made since the PivotTable was created. Look for deleted columns, inserted blank rows, merged cells, or a heading that was cleared or moved. Also check that the source data remains in the workbook and that the intended sheet has not been renamed in a way that breaks a reference.

  • Give every source column a heading, such as Date, Region, and Amount.
  • Make each heading unique; use labels such as Sales Amount and Tax Amount instead of two columns both named Amount.
  • Keep the header row directly above the records, without a separate title row inside the selected range.
  • Remove merged cells from the source area and avoid completely blank rows or columns that split the data.

A corrected header may be enough to resolve the error. Once the source is valid, refresh again. If Excel still reports an invalid field name, verify that the PivotTable is pointing to the range you inspected rather than to another sheet, an old range, or an external source.

Confirm that the source range includes new records

A PivotTable built from a fixed cell range may not automatically include data added below or beside that range. For instance, if the source was A1:D200 and a new record is entered in row 201, refreshing that PivotTable can update changes within the original range but omit the new record. Check the reference by clicking in the PivotTable and choosing PivotTable Analyze > Change Data Source. The dialog shows the current source; update it to include the full, correct range if appropriate.

For data that grows over time, an Excel table is often a more dependable source. Select a cell in the source records, choose Insert > Table, confirm that the table has headers, and select OK. After confirming the PivotTable uses that table as its source, new rows added to the table can be included when the PivotTable is refreshed. This does not mean the PivotTable updates instantly: refresh is still needed unless a refresh setting or automation handles it.

Be cautious when changing the source of a PivotTable connected to the Data Model or an OLAP source. Such PivotTables are not always handled like ordinary range-based PivotTables, and the standard Change Data Source workflow may not be available. In that case, check the model or connection that supplies the data rather than trying to replace the PivotTable source with a worksheet range.

Troubleshoot external connections and queries

If the PivotTable uses a database, text file, Power Query result, or another workbook, the issue may be with the connection rather than the PivotTable layout. Check that the source file or server is reachable, the file has not been moved or renamed, and the signed-in account has access. A password change, expired sign-in, VPN requirement, or unavailable network location can interrupt refresh.

For workbook connections, open Data > Queries & Connections and inspect the listed query or connection for an error or status message. If a PivotTable is based on a Power Query output, refresh the query or use Refresh All, then inspect the query result for errors. A query can fail before the PivotTable receives any updated rows, so repeatedly refreshing only the PivotTable may not solve the underlying issue.

When an error mentions credentials, permissions, or a server, resolve that access problem through the appropriate account or connection settings. Do not assume that changing the PivotTable range will repair an unavailable database. If the source belongs to an organization, its administrator may need to restore access or confirm that the data service is online.

Review refresh settings and workbook state

Excel can be configured to refresh data when a workbook opens, but that setting is not a guarantee that every source will be reachable or permitted to refresh. To review the setting for a conventional PivotTable, click inside it and open PivotTable Analyze > Options > PivotTable Options. On the Data tab, check Refresh data when opening the file if you want that behavior and the option is available for the PivotTable. External connections may have their own refresh controls.

Also make sure the workbook is editable and that the source is not in an unexpected state. A protected worksheet, read-only file, coauthoring conflict, or open source workbook that has unsaved changes can complicate an update. Save a copy before making structural changes, especially if the workbook contains important formulas, queries, or carefully arranged PivotTables.

If only one PivotTable fails, compare its source and settings with a PivotTable in the same workbook that refreshes successfully. If all connections fail, suspect a broader issue such as network access, credentials, or workbook configuration rather than a single field layout.

Understand stale values, missing items, and cache behavior

A refresh may not display what you expect even when Excel reports no error. First distinguish between missing records and an incorrect summary. A new record might not be in the source range, might be excluded by a report filter, or might contain a category value that differs slightly from existing entries. For example, North and North followed by a space can appear as separate PivotTable items.

Check the PivotTable filters, slicers, row and column labels, and the source values themselves. Then compare a few individual source records with the displayed total. If the source contains numbers stored as text, inconsistent dates, or blank values, the PivotTable may group or summarize them differently from what you intended. Correcting the data type or inconsistent value in the source and refreshing can clarify the result.

PivotTables may retain old item labels in their field lists or filters after source values have been removed. This is not necessarily evidence that the refresh failed: retained items and current source records are different things. For a conventional PivotTable, the number of retained items can be managed in PivotTable Analyze > Options > Data, where the Number of items to retain per field setting may be available. Changing it affects retained field items, not whether new source rows are included.

A practical order for diagnosing the failure

Use this sequence to avoid making unrelated changes before you know where the problem is:

  1. Read the full error message and note whether it names a field, source, connection, or permission.
  2. Check that the source file, worksheet, or database is available and that you can access it.
  3. Inspect the source headers for blanks or duplicates and look for structural changes.
  4. Confirm the PivotTable source reference includes all intended rows and columns.
  5. For a query-based source, check the query result and connection before refreshing the PivotTable again.
  6. Use PivotTable Analyze > Refresh, then compare a small sample of the result with the source.

Change one thing at a time and refresh again. If the workbook is large or contains multiple connections, save a copy before changing the source, query, or Data Model. That makes it easier to reverse an accidental change and helps identify which adjustment resolved the failure.

Excel for Mac and Excel for the web

The main troubleshooting ideas are similar in Excel for Mac: verify the source, inspect the connection, and refresh from the ribbon or the PivotTable context menu. Ribbon labels and available connection options can vary by platform and build, so a Windows path such as PivotTable Analyze > Change Data Source may not appear in precisely the same place on a Mac. Use the Mac ribbon’s PivotTable and Data controls, and consult the source-specific options when the PivotTable relies on an external connection.

Excel for the web can work with PivotTables, but refresh support depends on the data source and workbook features. If the web app cannot refresh a particular connection or exposes fewer controls, open the workbook in the Microsoft 365 desktop app, where connection and PivotTable options are more extensive. A workbook that refreshes in one environment but not another may reflect a feature or access difference, not damaged PivotTable data.

Frequently Asked Questions

Why does my Excel PivotTable say the field name is not valid?
A source column heading is often blank or duplicated, or the selected source range includes an unsuitable row or column. Make the header row complete and unique, confirm it is directly above the records, and verify that the PivotTable points to the intended range.

Why are new rows missing after I refresh a PivotTable?
The PivotTable may use a fixed range that stops before the new rows. Check PivotTable Analyze > Change Data Source and extend the range, or use an Excel table as the source so added table rows can be included on refresh.

Does Refresh All update every PivotTable?
Refresh All asks Excel to refresh eligible workbook connections and related data, but a failed or inaccessible connection can still prevent an update. A PivotTable can also remain incomplete if its source range omits the new records.

How do I make a PivotTable refresh when I open the workbook?
For a conventional PivotTable, check Refresh data when opening the file under PivotTable Analyze > Options > PivotTable Options > Data. External connections may have separate settings, and automatic refresh still depends on access to the source.

Can a PivotTable refresh in Excel for the web?
Some PivotTables and sources can be refreshed in the web app, but support varies with the connection and workbook features. If the refresh control or required connection settings are unavailable, open the workbook in desktop Excel.

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.