Excel Pivot Table Filter Not Working? Fixes That Help

If a filter in an Excel PivotTable is not working, first clear the filter, refresh the PivotTable, and confirm that the source data includes the rows you expect. In Excel for Microsoft 365 on Windows, select the PivotTable and use PivotTable Analyze > Clear > Clear Filters, then choose the filter again; if results are still missing or stale, use PivotTable Analyze > Refresh and check the source range.

A filter can appear broken for several different reasons: a field is filtered in another part of the PivotTable, the data cache has not refreshed, the source range omits new records, or a slicer is connected to a different PivotTable. The quickest fix depends on which kind of filter you are using and what result you expected.

Identify the filter you are using

PivotTables offer several filtering controls, and they do not all act in the same way. Before changing settings, identify where you applied the filter. A dropdown beside a row or column label filters that field. A dropdown in the Filters area above the report is a report filter. A slicer is a separate on-sheet button panel, while a timeline is a date-specific control.

There can also be more than one filter active at once. For example, a slicer may limit the report to one region while a row-label dropdown excludes a product. Clearing only the row-label filter will not remove the slicer selection. Look for funnel icons on field buttons and for highlighted selections in slicers or timelines.

Row or column label filter: limits the displayed items in that area.
Value filter: keeps items based on a calculation, such as sales greater than a threshold.
Report filter: selects one or more values for a field placed in the Filters area.
Slicer or timeline: filters through visible buttons and may control one or several PivotTables.

Clear filters and check the field selection

Start with a clean state so you can tell whether the problem is an old selection or a data issue. Click inside the PivotTable, choose PivotTable Analyze > Clear > Clear Filters, and then inspect the report again. You can also open a particular field’s dropdown and choose Clear Filter From followed by the field name. The exact wording may vary slightly with the selected field.

For a slicer, use its Clear Filter button, usually shown as a small funnel with a red X in the slicer header. A timeline has a similar clear-filter control. If the slicer header is hidden, right-click the slicer, choose Slicer Settings, and check whether the header is displayed.

Next, verify that the filter is on the intended field. A report filter for “Region” does not filter “Salesperson” unless the values happen to align. Likewise, a value filter applies to the values summarized by the PivotTable, not necessarily to the underlying source rows as a separate data-cleaning operation. If you set a value filter, confirm that the correct measure and comparison rule are selected.

Refresh the PivotTable after changing the source data

A PivotTable stores a summary of its source data in a cache. Editing the original worksheet does not always update that summary immediately. Select a cell in the PivotTable and choose PivotTable Analyze > Refresh. To update multiple PivotTables or external connections in the workbook, use Data > Refresh All. Refreshing can make newly added values available in filter lists and update totals.

Refresh does not automatically fix every source-range problem. If you added records below the original range, the PivotTable may still be looking only at the old cells. Select the PivotTable, choose PivotTable Analyze > Change Data Source, and check the range shown. Extend it to include the new records, or convert the source data to an Excel Table before building or updating the PivotTable. A Table generally expands as you add rows, making it a more reliable source for ongoing additions.

For example, if the original source covers A1:F500 and you add 30 records in rows 501–530, a PivotTable tied to the original fixed range will not include those records just because you refreshed it. The source must include the extra rows. After correcting the range, refresh again and check whether the new values appear in the dropdown.

Look for blanks, inconsistent entries, and data-type differences

Filter lists reflect the values Excel recognizes in the source field. Entries that look alike to a person may be different to Excel: “North”, “North ” with a trailing space, and “NORTH” can be separate text items. A blank cell may appear as “(blank)”, and a formula returning an empty string may behave differently from a truly empty cell. These variations can make it seem as though a filter is missing, duplicating, or failing to combine items.

Check the source column for extra spaces, inconsistent spelling, blank cells, and mixed data types. A date column that contains real dates alongside text that resembles dates can sort or filter unexpectedly. Numbers stored as text may also be grouped separately from numeric values. Correct the source consistently, then refresh the PivotTable. If you change source values, remember that the displayed labels and filter choices will follow those corrections.

When the source is large, inspect a few affected rows rather than assuming the dropdown is wrong. Use the worksheet’s Find command or sort the source column to bring unusual entries together. Avoid deleting “(blank)” from the PivotTable merely to hide a data-quality issue if blank records matter to the report.

Check label filters, value filters, and date filters

Label filters and value filters answer different questions. A label filter tests the item name—for example, keeping product names that begin with “Desk.” A value filter tests the summarized number—for example, keeping products whose total sales exceed $1,000. If the rule is applied to the wrong field or measure, the resulting list can look unrelated to the intended condition.

Open the dropdown for the relevant row or column field and review the active filter type and criteria. For a value filter, check the selected value field, such as Sum of Sales, and whether the condition is greater than, less than, or between the intended amounts. If a report has multiple measures, choosing Count instead of Sum can materially change which items qualify.

Date filters can be confusing when the source contains mixed or invalid dates. Check whether the field is grouped into years, quarters, or months, and whether the filter is being applied at the level shown. A filter on a grouped year is not the same as a filter on individual dates. If grouping is not appropriate, right-click a date item and choose Ungroup, then refresh and review the field again.

Verify slicer connections and PivotTable layout

A slicer may be working correctly but connected to a different PivotTable than the one you are watching. Select the slicer and choose Slicer > Report Connections (the tab may be labeled Slicer when the slicer is selected). In the dialog, check the boxes for the PivotTables it should control. The command is available only when a slicer is selected.

Report Connections can be limited by how the PivotTables were created. PivotTables generally need to share the same data source or PivotTable cache for a slicer to control them together. If the intended report is not listed, it may not be compatible with that slicer’s connections. Consider creating the PivotTables from a common source, or use separate slicers where the reports cannot share a cache.

Also check the layout. A field in the Filters area controls the report from a dropdown above the PivotTable; it will not behave like a row-label dropdown. If the field list is missing, click inside the PivotTable and choose PivotTable Analyze > Field List. In a protected worksheet, Excel may block changes to PivotTable reports depending on the protection settings. If you are authorized, review the sheet protection settings rather than trying to work around them.

Remove stale items from filter dropdowns

Sometimes a filter dropdown continues to show an item that has already been removed from the source. This is different from the filter failing to exclude data: the dropdown may be retaining an old item from the PivotTable cache. First refresh the PivotTable. If the obsolete item remains, select the PivotTable and open PivotTable Analyze > Options. In the PivotTable Options dialog, open the Data tab and set Number of items to retain per field to None, then refresh the PivotTable.

Be aware that retaining old items can be useful when reports need to preserve historical labels, so changing this setting may alter what users can select. It removes retained items that are no longer present in the current source; it does not restore omitted records or repair an incorrect source range.

When the usual fixes do not work

If a filter still gives unexpected results, narrow the problem down systematically. First, compare the PivotTable’s source range with the actual data. Then refresh, clear all filters, and apply one simple filter to one field. If that works, add the other filters back one at a time. This reveals whether two simultaneous conditions, a slicer selection, or a value-filter rule is responsible.

Confirm that the PivotTable is selected before using PivotTable Analyze commands.
Check the source range or Table and confirm that affected records are included.
Refresh the PivotTable, then inspect the dropdown for the expected item.
Clear slicers, timelines, report filters, and field filters separately.
Check for blanks, trailing spaces, inconsistent labels, and text-versus-number differences.
Verify that the field and summary measure match the filter rule you intended.

If the workbook is shared or connected to an external data source, access permissions, connection settings, or refresh failures may be involved. Review any message shown by Excel and confirm that the source can be reached. In Excel for Mac and Excel for the web, the PivotTable concepts are similar, but ribbon organization and available commands can differ from the Windows steps above. Look for the PivotTable or Data refresh commands in that version, and use the version’s slicer connection controls where available.

Frequently Asked Questions

Why does my PivotTable filter not show new items?

Refresh the PivotTable first. If the new items still do not appear, check whether the source range includes the new rows. A refresh updates the cache, but it cannot include records that lie outside the PivotTable’s source range.

Why does a PivotTable show “(blank)” in the filter?

At least one source record may have an empty value in that field, or a formula may produce an empty result. Inspect the source column and decide whether to correct, retain, or exclude those records before filtering the blank item out of the report.

Why does my slicer not filter every PivotTable?

The slicer may not be connected to all of them. Select it and review Slicer > Report Connections. If a PivotTable is not listed, the reports may not share a compatible cache or data source, so they may need separate slicers or a common source.

Why are deleted values still in the PivotTable filter list?

The PivotTable may retain old items in its cache. Refresh first; if they remain, set Number of items to retain per field to None under PivotTable Options > Data, then refresh again.

Does refreshing a PivotTable change the original data?

No. Refresh updates the PivotTable summary from its source; it does not rewrite the source records. To correct misspelled labels, missing dates, or other source issues, edit the original data and then refresh the PivotTable.

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.