Excel Pivot Table Not Updating? Fix It Step by Step

Charts & pivot tables · Updated November 18, 2026

If an Excel PivotTable is not updating, click inside it and select PivotTable Analyze > Refresh; to refresh all PivotTables and workbook connections, select Data > Refresh All. If new rows still do not appear, check that the PivotTable’s source includes them, then check filters, calculations, and any external data connection.

Refresh the PivotTable first

A PivotTable usually displays a stored snapshot of its source data rather than recalculating every summary whenever a source cell changes. Refreshing tells Excel to read the source again and rebuild the summary. For a single PivotTable in Excel for Microsoft 365 on Windows, click anywhere in the PivotTable and choose PivotTable Analyze > Refresh. You can also right-click a PivotTable cell and choose Refresh.

If the workbook contains several PivotTables or data connections, use Data > Refresh All. This can take longer because Excel may need to update queries or connections as well as PivotTables. Wait for the refresh to finish before deciding that nothing changed. A refresh can also fail or pause when the source is on a network, requires sign-in, or is temporarily unavailable; look for a status message or error rather than assuming the PivotTable itself is broken.

Refresh is different from recalculation. A refresh rereads the PivotTable’s source, while recalculation updates formulas in worksheet cells. If a source formula has not recalculated, refreshing the PivotTable may simply import its old result.

How PivotTable refresh works

Excel builds a PivotTable from a source such as a worksheet range, an Excel table, an external connection, or the workbook Data Model. It keeps a cache or other stored representation of that data so it can arrange and summarize fields quickly. The displayed totals therefore may not change at the moment you edit a source cell. Refreshing updates the stored data and then recalculates the PivotTable layout and results.

This explains a common misconception: a refresh cannot include records Excel does not know are part of the source. If a PivotTable is based on A1:D500 and you add a record in row 501, refreshing that fixed range still reads only rows 1 through 500. The PivotTable can refresh successfully and still appear unchanged. Similarly, a filter can hide a new record, and a source formula can continue to return an old value if calculation is set to manual.

Check the PivotTable source range

When added rows are missing, inspect the source before repeatedly refreshing. Click the PivotTable and select PivotTable Analyze > Change Data Source. Review the range or table name shown in the dialog. If it is a fixed cell range, confirm that the new rows and all required columns fall inside it. Correct the reference if needed, select OK, and refresh.

For data that grows over time, an Excel table is often more reliable than a fixed range. Select a cell in the source data and choose Insert > Table, making sure the header option is correct. Give the table a clear name using the Table Design tab. Then base the PivotTable on that table. When records are added directly beneath the table, Excel generally expands the table; check the table boundary after pasting, because a blank row or column can prevent data from being included. Refresh the PivotTable after adding records.

Also check the source headers. Each column needs a unique, nonblank heading. A pasted column without a proper header, merged header cells, or an accidental blank row within the data can make the range behave unexpectedly. If you added a new source column, update the PivotTable source so that the column is included; refreshing the old source alone does not add a field that lies outside it.

Look for filters and layout choices that hide changes

A record can be present in the refreshed PivotTable but not visible. Check the filter arrows beside row and column labels, the Filters area in the PivotTable Fields pane, and any slicers or timelines connected to the PivotTable. A selected year, category, or region may exclude the new record. Clear or adjust the relevant filter, and use the filter’s search box if the list is long.

Also check whether the changed source field is actually used in the PivotTable. A new value in a field that is not placed in Rows, Columns, Values, or Filters will not necessarily appear on the sheet. If the field is in Values, its summary may be Count rather than Sum, or another calculation may make the result look unexpected. Right-click a value, choose Summarize Values By, and verify the aggregation that fits the data.

Old labels can sometimes remain available in a field’s filter list even after those labels disappear from the current source. That does not always mean old records are still being included in the displayed totals. To clear retained items, right-click the PivotTable, choose PivotTable Options, open the Data tab, and set Number of items to retain per field to None; then refresh. The precise options available can depend on the PivotTable’s source type.

Check formulas and calculation settings

If the PivotTable source includes formulas, first make sure those formulas show the expected results in their cells. In Excel for Microsoft 365 on Windows, select Formulas > Calculation Options > Automatic to make the workbook recalculate formulas automatically. If calculation is set to Manual, changing an input may leave formula results unchanged until recalculation. Press F9 to recalculate open workbooks, or Shift+F9 to recalculate the active worksheet, and then refresh the PivotTable.

For example, suppose a source table has a calculated Revenue column based on Quantity and Unit Price. If Quantity changes while calculation is manual, the Revenue cell may still show its previous value. Refreshing the PivotTable can faithfully summarize that stale cell value. Recalculate first, verify the source column, and then refresh. If the formulas themselves return blanks, text, or errors, check their inputs and the field’s number format as well.

A PivotTable’s own calculated field or calculated item is different from a worksheet formula. If one of these is used, review its definition and the fields it references. A refresh does not repair a wrong calculation definition, and a displayed total may be correct for the definition even if that is not the result you intended.

Refresh Power Query and external data sources

For a PivotTable based on Power Query, a database, or another external connection, the source may have to refresh before the PivotTable can show current records. Choose Data > Refresh All and allow the query or connection to complete. If the PivotTable uses the workbook Data Model, refresh the query or model data that feeds it; changing a worksheet cell is not enough if that cell is not the model’s source.

If the refresh reports an error, check whether the file, server, or database is reachable and whether the connection still has valid credentials. The source may also have changed its column names or structure. A connection can be configured to refresh in the background, so the PivotTable may not update immediately; wait for completion and check the query or connection status. For a business database, ask the workbook owner or data administrator about access rather than changing connection settings blindly.

In some workbooks, refreshing a PivotTable and refreshing its underlying query are separate operations. Data > Refresh All is a useful first choice, but if the query itself fails, the PivotTable cannot display data that was never loaded. Open the query or connection details and resolve the source error first.

A quick troubleshooting sequence

Use this order to narrow down the cause without changing several settings at once:

  1. Click in the PivotTable and select PivotTable Analyze > Refresh. For a workbook-wide update, use Data > Refresh All.
  2. Check whether the new or changed value is visible in the source data. If formulas supply it, recalculate and confirm their results.
  3. Choose PivotTable Analyze > Change Data Source and verify that the source range, table, or connection includes the relevant records and fields.
  4. Inspect PivotTable filters, slicers, and the fields in the layout. Temporarily clearing a filter can reveal whether it is hiding the changed item.
  5. If external data is involved, check for a failed query, sign-in request, or connection error and wait for the refresh to finish.

If the displayed result is still unexpected, compare a small, easily checked subset of the source with the PivotTable. For example, filter the source to one category and add its visible amounts manually or with a worksheet total. This helps distinguish a source-range problem from a filter or aggregation issue. Avoid deleting and rebuilding the PivotTable as a first response: doing so can discard its layout, formatting, and custom settings without fixing a faulty source.

Windows, Mac, and Excel for the web

The instructions above use Excel for Microsoft 365 on Windows. In Excel for Mac, click inside the PivotTable and use the contextual PivotTable tab’s refresh command, or right-click the PivotTable and choose Refresh. Ribbon labels and dialog placement can vary slightly by Mac release, but the source-range, filter, and connection checks are the same. If you do not see a PivotTable tab, first select a cell inside the PivotTable.

Excel for the web also provides PivotTable refresh options in supported workbooks, but available connection and data-model features can differ from the desktop app. If an external source cannot be refreshed in the browser, open the workbook in the desktop version that supports that connection. Keep an unchanged copy before making structural edits to an important workbook.

Frequently Asked Questions

Why does my PivotTable not include new rows?

Most often, the PivotTable uses a fixed source range that stops before the new rows. Use PivotTable Analyze > Change Data Source to inspect it. Consider converting the source to an Excel table so it can expand as records are added, then refresh the PivotTable.

Does a PivotTable update automatically when source cells change?

Usually, no: a standard PivotTable displays cached source data until it is refreshed. Use PivotTable Analyze > Refresh after edits, or enable a suitable refresh-on-open option in the PivotTable or connection settings if that matches your workflow. Refresh-on-open does not mean every edit updates immediately.

Why does Refresh All not update my PivotTable?

Check that the source includes the changed data, that source formulas have recalculated, and that no filter hides the result. If the PivotTable depends on a query or external connection, inspect its refresh status and any error message. Refresh All cannot include data that the source range or connection does not return.

Why does my PivotTable show old items after refreshing?

Old field labels may be retained in the PivotTable’s item list even when they are no longer in the source. In PivotTable Options > Data, set Number of items to retain per field to None and refresh. Also make sure a filter is not selecting an old item or excluding a current one.

What is the difference between Refresh and Refresh All?

Refresh updates the selected PivotTable. Refresh All updates workbook PivotTables and refreshable data connections, which is useful when several reports depend on the same imported data. It can take longer, and a connection error may prevent the affected report from receiving current data.

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.