Excel Pivot Table Not Refreshing? Fix the Data Source

Charts & pivot tables · Updated November 21, 2026

If an Excel PivotTable is not showing your latest data, select a cell in it and choose PivotTable Analyze > Refresh, or use Data > Refresh All to update every connection and PivotTable in the workbook. If the new rows still do not appear, check whether the PivotTable’s source range includes them; refreshing cannot add records that are outside its source.

Why a PivotTable can look out of date

A PivotTable summarizes data from a source, such as a worksheet range, an Excel table, a query, or the workbook Data Model. It is not a live view of every cell in that source. Excel stores a snapshot of the source data in a PivotTable cache or retrieves data through a connection. When source values change, the summary generally stays as it was until you refresh it.

This behavior is useful: the report does not have to recalculate every time someone edits a source cell. But it also means that changing a number, adding a record, or updating a query does not necessarily change the displayed totals immediately. A refresh asks Excel to read the source again and rebuild the summary.

First identify what changed. If an existing value changed but the PivotTable did not, a refresh may be enough. If you added rows, check the source boundary. If the numbers are current but the wrong items are visible, investigate filters or grouping instead. Those are different problems and require different fixes.

Try these quick refresh steps

For a standard PivotTable in Excel for Microsoft 365 on Windows, start with the selected PivotTable:

  1. Click any cell inside the PivotTable. This makes its contextual ribbon tab available.
  2. Choose PivotTable Analyze > Refresh. In some ribbon layouts, the tab may be labeled Analyze.
  3. To refresh all PivotTables and connections in the workbook, choose Data > Refresh All.
  4. Wait for any query or connection refresh to finish, then check the relevant totals and row labels.

You can also right-click inside a PivotTable and choose Refresh. If you have several reports that use the same data, Refresh All is a practical first check, but it can take longer because it updates other workbook connections too. Pressing F9 recalculates worksheet formulas; it does not, by itself, refresh a PivotTable’s source data.

If the refresh command is unavailable, confirm that you clicked inside a PivotTable and that the sheet or workbook is not protected in a way that prevents the action. If the file is read-only, you may be able to refresh it but not save the updated workbook. Save a working copy if you need to preserve refreshed results.

Check whether the source includes the new rows

A frequent cause is that the PivotTable points to a fixed range, such as A1:D200, while new records were entered on row 201 or below. Refreshing reads the source Excel already knows about; it does not automatically extend every fixed range to include nearby data.

To inspect or change a worksheet-based source, click the PivotTable and choose PivotTable Analyze > Change Data Source > Change Data Source. Review the range shown in the dialog. If it stops before the new records, select the full range, including its header row, and confirm. The dialog and available options can differ for PivotTables based on the Data Model or an external connection; those sources are managed through their model or connection rather than by simply editing a worksheet range.

For regularly growing source data, an Excel table is usually easier to maintain than a manually selected range:

  • Make sure the source has one clear header row, with a distinct, nonblank heading for each column.
  • Click in the source data and choose Insert > Table, or press Ctrl+T on Windows. Confirm that the table has headers if it does.
  • When you add records directly below the table, Excel generally expands the table to include them. Refresh the PivotTable afterward so the summary reads the added records.
  • If the PivotTable was created from a fixed range before the data was converted to a table, changing the source to the table may be needed. Use Change Data Source and select the table as the source where that option is available.

Check the table boundary if Excel did not expand it, especially when blank rows or columns separate new entries from the existing table. Also confirm that the records are in the correct columns. A value typed beside the table rather than in it is not part of its source.

Understand what Refresh and Refresh All update

Refresh updates the selected PivotTable from its current source. Refresh All is broader: it requests updates for the workbook’s data connections and PivotTables. In a workbook built with Power Query, a query may need to finish loading before a dependent report reflects the result, so allow time for the refresh to complete rather than checking midway through.

For a PivotTable based on a local range or table, refreshing updates the summary from the current worksheet data. For a connection to an external database, file, or service, Excel must also be able to reach that source and obtain usable data. A successful-looking click is not proof that an unavailable source supplied new records; look for connection errors and check whether the report’s values actually changed.

You can control whether a PivotTable refreshes when the workbook opens. Select the PivotTable, open PivotTable Analyze > Options, and use the Data tab in PivotTable Options to enable Refresh data when opening the file. This setting can help reports that should open with current source values, but it does not fix a wrong source range or a broken connection. For an externally connected workbook, refresh may still depend on access, credentials, and the source being available.

Look for filters, grouping, and field changes

Sometimes the PivotTable has refreshed correctly but the updated result is hidden. Check the filter arrows in the report, any slicers or timelines, and the Filters area in the PivotTable Fields pane. A filter may exclude the new category or date. Clear or adjust the relevant filter and see whether the missing item appears.

Also inspect the source values themselves. A category that looks identical to an existing label may contain a trailing space or a spelling difference, creating a separate PivotTable item. Dates stored as text may not group or sort like real dates. If you correct source entries, refresh again and inspect the field items.

If source columns were renamed, removed, or given different headers, the PivotTable’s field layout may no longer match the source. A missing field in the field list can indicate that the source changed or that the wrong source is selected. Recheck the header row and source, then rebuild the report layout if necessary. Refreshing data does not always repair a report whose fields have been changed or deleted.

For a PivotTable that retains old labels after a source item was deleted, select it and open PivotTable Analyze > Options. On the Data tab, look for Number of items to retain per field and choose None, then refresh. This setting controls retained items in the cache; it is separate from filtering and does not restore records that are still present in the source.

When queries, connections, or the Data Model are involved

If the PivotTable is built from Power Query, an external connection, or the Data Model, trace the full data path. First check that the query or connection itself refreshes successfully. Then confirm that its output contains the changed rows and that the PivotTable uses that output or model. Updating a worksheet table that is not connected to the report will have no effect on the PivotTable.

For a connection problem, open Data > Queries & Connections and inspect the relevant query or connection for a status or error. The pane and available details depend on the source and workbook. Check that the source file has not moved, the database or service is reachable, and any required sign-in is still valid. If a query filters out rows, refresh will faithfully reproduce that filtered result; adjust the query steps if the exclusions are no longer intended.

Some connections can refresh in the background. In that case, the worksheet may still show the previous result while the update is running. Wait for completion and check the connection status before judging the report. If Refresh All returns an error, note which connection failed; another PivotTable may have updated successfully even when one source did not.

Common misconceptions and ways to prevent the problem

Refresh does not mean recalculate every workbook formula, expand every fixed range, remove every filter, or repair every source connection. It updates data from the source configured for that PivotTable. That distinction explains why repeating the same refresh command often does nothing: the issue may be the source definition, not the refresh itself.

To reduce recurring problems, keep source data in a consistent table with one header row and no blank separator rows. Add new records within or directly beneath the table, avoid changing column names without updating dependent reports, and use clear date and number types. Before distributing a workbook, test its refresh on a copy and confirm that the intended source is accessible to its recipients.

When a report is critical, compare one or two PivotTable totals with a direct check of the source records after refreshing. This helps distinguish a stale report from a filter or data-quality issue. It also catches cases where a query successfully refreshed but intentionally or accidentally excluded some rows.

Frequently Asked Questions

Why is my PivotTable not updating when I change a cell?
PivotTables do not always update immediately after a source edit. Click inside the report and choose PivotTable Analyze > Refresh. If the edit added a row, confirm that the row is inside the PivotTable’s source range or Excel table.

How do I make a PivotTable include new rows automatically?
Use an Excel table as the source rather than a fixed cell range. Add new records to the table, then refresh the PivotTable. A table can expand as records are added, but the PivotTable still needs a refresh to summarize them.

Does pressing F9 refresh a PivotTable?
No. F9 recalculates formulas in Excel; it is not the command for refreshing PivotTable data. Use Refresh for the selected PivotTable or Data > Refresh All for the workbook.

Why does Refresh All not update my external-data PivotTable?
Check the connection status, source availability, and any required credentials. Also check whether a query filters out the expected records. If the connection is still running in the background, wait for it to finish before checking the report.

Why do deleted items still appear in my PivotTable filter?
The PivotTable cache may retain old field items. In PivotTable Options on the Data tab, set Number of items to retain per field to None, then refresh. This removes retained items; it does not change which records are currently in the 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.