Excel Pivot Table Filter Not Refreshing? Fixes That Work

Charts & pivot tables · Updated November 19, 2026

If an Excel pivot table filter is not refreshing, first select the PivotTable and choose PivotTable Analyze > Refresh; then confirm that its source includes the new or changed data. If the filter still shows old items, clear the filter, check the PivotTable’s source range, and refresh the relevant query or connection as well.

Why a PivotTable filter can look stale

A PivotTable does not continuously read every source cell as you change the worksheet. It uses a PivotCache, a stored representation of the source data, to build its summaries and filter lists. Refreshing tells Excel to update that representation from the source. Until then, the PivotTable can show old totals, omit new categories, or retain categories that no longer appear in the source.

There are also two different things people mean by “the filter is not refreshing.” The field’s dropdown list may not include a new item, or a selected filter may continue to hide rows that the user expects to see. The first often points to a refresh or source-range issue. The second may simply be an active filter, a slicer selection, or a label that differs slightly from the one in the source, such as “West” versus “West ” with a trailing space.

Refreshing does not automatically fix every problem. It cannot bring in rows that are outside the PivotTable’s source, correct inconsistent source labels, or refresh an external connection that has failed. Identify which of those situations applies before rebuilding the PivotTable.

Refresh the PivotTable and clear its filter

Start with the simplest refresh. Click anywhere inside the PivotTable so its contextual ribbon tab appears, then choose PivotTable Analyze > Refresh. You can also right-click inside the PivotTable and choose Refresh. The command refreshes that PivotTable using its current source and cache.

Next, check whether the filter itself is restricting the results. Open the dropdown beside the relevant row or column field and choose Clear Filter From followed by the field name, or select all the items you want included. The wording can vary slightly with the field layout. To remove filters from the entire PivotTable, use PivotTable Analyze > Clear > Clear Filters. This removes filter selections; it does not change the source data or the PivotTable’s source range.

If the PivotTable uses a slicer, click the slicer’s clear-filter icon, usually shown as a small funnel with a red mark. A slicer can keep a selection active even when the field dropdown looks as though it should show more data. When several PivotTables share a slicer, inspect its report connections too: a slicer may control some PivotTables but not others.

  • New source item missing: refresh, then confirm the source includes the row and its field value.
  • Expected rows hidden: clear the field filter and any slicer selections.
  • Old item still listed: refresh and check the PivotTable’s retained-item setting.

Check whether the source range includes the new rows

A refresh only reads the range or connection assigned to the PivotTable. With a fixed cell range, rows added below the original range are not necessarily included. For example, a PivotTable based on A1:D500 will not include a new record entered in row 501 unless the source is expanded. The PivotTable may refresh successfully and still appear out of date because Excel has refreshed exactly the range it was given.

To inspect or change the source, click in the PivotTable and choose PivotTable Analyze > Change Data Source. Check the address or table name in the dialog. If the source should include more worksheet rows, select the correct expanded range and confirm. Make sure the first row contains usable column headings: blank or duplicate headers can prevent Excel from treating the source as a valid table.

For data that grows regularly, an Excel Table is usually more reliable than a fixed range. Select the source and choose Insert > Table, or press Ctrl+T on Windows, and confirm that the table has headers. When the PivotTable uses the table as its source, new rows added to that table are included when you refresh. If a pasted row did not become part of the table, check the table boundary or use Table Design > Resize Table. Converting a source to a Table does not necessarily change an existing PivotTable’s source automatically; check Change Data Source to verify what it uses.

Remove old items from a filter list

Sometimes a filter list shows categories that were deleted from the source. This can happen because the PivotCache retains previously seen items. Refresh the PivotTable first. If old values remain, right-click inside the PivotTable and choose PivotTable Options. On the Data tab, find Number of items to retain per field and set it to None, then refresh again. The exact dialog placement can vary a little between Excel builds, but this setting is in the PivotTable’s options, not in the source worksheet.

That setting addresses obsolete items in filter lists; it does not recover missing current values. If a new value is absent, return to the source-range check and confirm the new row is included. Also inspect the source spelling and spacing. Excel treats “North” and “North ” as different text values, so an unexpected extra entry can be a data-cleaning issue rather than a refresh failure.

For a quick check, use Find on the source column to locate the category, then inspect the surrounding rows and the table boundary. If values were generated by formulas, confirm the formulas have recalculated. On Windows, Formulas > Calculation Options > Automatic sets automatic calculation; pressing F9 recalculates the workbook. A PivotTable refresh reads the current results of source formulas, so a stale formula result can make a correctly refreshed PivotTable look wrong.

Refresh all queries, connections, and PivotTables

If the PivotTable is built from a query, external file, database, or other workbook connection, refreshing only the PivotTable may not update the connection’s underlying data. Choose Data > Refresh All to request a refresh of workbook data connections and PivotTables. Depending on the source, Excel may display a progress indicator or ask for credentials. If the connection cannot reach its source, the refresh can fail or leave data unchanged; check the message and connection settings rather than assuming the filter itself is broken.

A PivotTable based on the Data Model or Power Query can have more than one update step: the query or model must receive current data, and the PivotTable must then reflect that data. Refresh All is a useful first step, but it cannot resolve missing access, an unavailable file, or a query that returns no new rows. Open Data > Queries & Connections to review query status and connection details where available. For a shared workbook, also check whether the source file has actually been updated and saved.

Excel for the web can refresh some PivotTables and connections, but support depends on the source and workbook features. If a command is unavailable or the workbook uses a feature that the web version cannot refresh, open it in the desktop app. On Mac, the PivotTable tools and refresh controls are similar, but ribbon placement and keyboard shortcuts differ from Windows; use the visible PivotTable and Data tabs rather than relying on a Windows-only shortcut.

Set refresh behavior for future openings

A PivotTable does not necessarily refresh every time its workbook opens. To request an opening refresh, right-click inside it, choose PivotTable Options, open the Data tab, and select Refresh data when opening the file, if that option is available for the PivotTable’s source. This is useful when the underlying source is expected to change between sessions. It is not a substitute for checking the source: a fixed range still excludes rows outside that range, and a connection still needs access to its data.

For workbooks with multiple queries and PivotTables, Data > Refresh All is often the more complete manual routine. Consider the workbook’s size and connections before refreshing: external data may take time to download, require sign-in, or be subject to a data provider’s availability. If the file is shared, agree on who updates the source and when, so readers do not mistake an old saved snapshot for current data.

A practical example and common misconception

Suppose a sales PivotTable has a Region filter listing East, Central, and West. A new transaction for South is entered immediately below a fixed source range that ends at row 800. Clicking Refresh will not add South because row 801 is outside the assigned source. The right fix is to expand the range through Change Data Source, or use a source Table that includes the new row, and then refresh. If South is already in the source but absent from the dropdown, refresh and check whether the PivotTable points to that source. If South appears but is not displayed in the report, clear the Region filter or slicer selection.

A common misconception is that refreshing a PivotTable changes the underlying source. It does not: the source remains as it was, and refresh updates the PivotTable from it. Nor does clearing a filter refresh data; it only changes which cached items are shown. Keeping those operations separate makes troubleshooting faster: verify the source, refresh the data, and then adjust the display filter.

Frequently Asked Questions

Why does my PivotTable not show new rows after I click Refresh?
Most often, the new rows fall outside a fixed source range. Use PivotTable Analyze > Change Data Source to check it, extend the range, and refresh. An Excel Table can make regularly growing sources easier to manage.

How do I make a new item appear in a PivotTable filter?
Confirm that the item exists in a source row included by the PivotTable, then refresh. If it remains missing, check the source field for inconsistent text, blank headers, or a query that has not loaded the new row.

Why does my PivotTable filter still show deleted items?
The PivotCache may retain old field items. Refresh, then check PivotTable Options > Data > Number of items to retain per field and choose None. Refresh again to update the list.

Does Refresh All update every PivotTable?
Refresh All requests updates for workbook data connections and PivotTables, but the result depends on the source, connection status, and workbook features. If one PivotTable remains stale, refresh it directly and inspect its source or connection.

Can I set a PivotTable to refresh automatically?
You can enable Refresh data when opening the file in PivotTable Options when the setting is available. This refreshes on opening, not necessarily every time the source changes while the workbook stays open.

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.