If an Excel PivotTable filter is not working, first refresh the PivotTable and check that its source data includes the rows you expect. Then clear other filters and verify that you are filtering the correct field; stale source ranges, date or value filter rules, and slicers that are not connected are common causes.
How PivotTable filters work
A PivotTable summarizes records from a source range or Excel table. Its filters affect which source records contribute to the summary, but different controls act at different levels. A dropdown beside a row or column label filters that field; a Report Filter appears above the PivotTable; and a slicer is a separate visual control. A filter on one field can also affect what appears in another field’s list.
This distinction helps explain a frequent misunderstanding: filtering a PivotTable does not filter or delete rows in the original worksheet. It changes the displayed summary. Likewise, applying a worksheet AutoFilter to the source data is not a substitute for filtering the PivotTable, and it may not produce the expected summary until the PivotTable is refreshed.
To filter a row or column field, select its dropdown arrow, clear Select All if needed, choose the items to show, and select OK. For a Report Filter, use the dropdown above the PivotTable. To remove PivotTable filters, select a cell in the PivotTable and use PivotTable Analyze > Clear > Clear Filters. This clears filters on that PivotTable, so reapply any selections you still need.
Refresh the PivotTable and check its source
PivotTables do not always update immediately when someone edits the source data. If new records, changed labels, or corrected values are missing, select a cell in the PivotTable, right-click, and choose Refresh. On the Windows desktop, you can also use PivotTable Analyze > Refresh. To refresh all connections and PivotTables in the workbook, choose Data > Refresh All.
Next, confirm that the PivotTable’s source includes the records in question. Select the PivotTable, then choose PivotTable Analyze > Change Data Source. Check the displayed range or table name, and correct it if necessary. A fixed range such as A1:D500 will not automatically include a new record entered in row 501. If the source is an Excel table, added rows are usually included when the PivotTable is refreshed.
- Look at the source worksheet and confirm that the missing records are actually there.
- Check that the source range includes every relevant row and column, including the header row.
- Refresh the PivotTable after changing the source or adding records.
- If the source is an external connection or data model, confirm that its refresh completed successfully.
For a regularly growing list, formatting it as an Excel table can make the source easier to maintain. Select a cell in the data and choose Insert > Table, then confirm that the table has headers. If you change the PivotTable source to that table, later rows can be incorporated on refresh without manually extending a cell range. This does not make the PivotTable live: refresh is still needed to update its summary.
Check which field and filter type you are using
A field can be placed in Rows, Columns, Values, or Filters in the PivotTable Fields pane. Its location affects what filtering controls are available. For example, a field in Rows has a dropdown beside its row labels, while a field in Filters has a separate selector above the report. If the expected arrow is missing, open the field list and check that the field is in the area you think it is.
Also inspect whether the filter is a basic item selection or a rule. Label Filters can show items that begin with particular text, while Value Filters can restrict items according to their summarized values. A rule such as greater than 100 applies to the field’s values in the PivotTable, not necessarily to the raw numbers in each source row. If the summary method or data changes, the results can differ from what you expect.
Open the field dropdown and check the filter indicators and selected items. If a rule is active, open the relevant Label Filters or Value Filters submenu to review or clear it. A filter may appear to do nothing when every item still meets the rule; conversely, it may hide everything if the rule is too restrictive. To test, clear the field’s filter and apply a simple item selection first.
Look for blanks, inconsistent labels, and dates
Source-data inconsistencies can make a filter list look incomplete or split one category into several entries. For instance, Sales and Sales followed by a space may appear as separate items. The same can happen with inconsistent punctuation, spelling, or number formats. Check the original column for near-duplicates, leading or trailing spaces, and values stored with different types, then correct the source and refresh.
A blank entry in a filter list usually means at least one source record has an empty cell in that field. It may also reflect formulas that return an empty string. Choose the blank item to inspect those records, or correct the source if the blank is unintended. Do not assume that hiding the blank item removes or repairs the underlying data.
Date filters deserve special attention. Excel may group dates into years, quarters, or months, and a date column containing text values or invalid entries can prevent consistent grouping. Check that the source column contains real Excel dates rather than text that merely looks like a date. If dates are grouped, expand the relevant year or month level and check the filter there as well as at the original date field. Correct the source values, refresh, and regroup if the displayed groups no longer match the data.
Check slicers and connections
A slicer can make filtering easier, but it can also be the source of confusion. A selected slicer button filters the PivotTable; a slicer showing multiple selected buttons may not represent the one category you intended. Select the slicer’s Clear Filter button, usually shown as a small filter with a red mark, to remove its selection. Then choose the desired item again.
If a slicer does not affect a particular PivotTable, check its connections. Select the slicer and choose Slicer > Report Connections (called PivotTable Connections in some Excel interfaces). Tick the PivotTables it should control. Connections are generally available only for PivotTables that share a compatible data source or cache; unrelated PivotTables cannot necessarily be linked just because their fields have the same names.
Other filters can remain active alongside a slicer. For example, a slicer may select one region while a row-field dropdown excludes a product. The combined result can look empty even though the slicer is functioning correctly. Clear the slicer and the field filters, then add selections one at a time to identify which control is narrowing the results.
Investigate old items and PivotTable options
Sometimes the filter list contains values that no longer exist in the current source data. This is often a retained-item issue, not proof that the filter is broken. Refresh first. If obsolete entries remain, select the PivotTable, open PivotTable Analyze > Options, and look for the Data tab in PivotTable Options. Set Number of items to retain per field to None, confirm, and refresh again. The exact dialog layout can vary slightly by Excel build.
Be cautious when changing PivotTable options: some settings control layout, formatting, and how fields are displayed, not filter selection. If a refresh changes the appearance of the report, review options such as preserving cell formatting on update rather than assuming the filter caused the change. Retained items can also be useful when a report needs to preserve historical labels, so remove them only when the old entries are genuinely unwanted.
Rule out protection, sharing, and platform differences
A protected worksheet may prevent users from changing a PivotTable or its filters, depending on how protection was configured. If filter controls are unavailable or commands are disabled, ask the workbook owner whether the sheet is protected and whether PivotTable use is allowed. Unprotecting a sheet requires the appropriate permission or password; do not try to bypass an organization’s workbook controls.
In Excel for Microsoft 365 on Windows, the ribbon paths above apply to the desktop interface. Excel for Mac has similar PivotTable concepts, though tab names and dialog placement can differ by version. Excel for the web supports common PivotTable filtering and refresh tasks, but some advanced options and data-source workflows may be limited compared with desktop Excel. If a command is unavailable, open the workbook in the desktop app before changing its source or less common settings.
A reliable troubleshooting sequence
When the cause is unclear, work from the source outward rather than changing many settings at once. This makes it easier to spot the problem and avoid losing a useful report layout.
- Confirm the source records and headers contain the values you expect.
- Check PivotTable Analyze > Change Data Source for the correct range or table.
- Refresh the PivotTable, then verify whether the missing item appears.
- Clear filters on the PivotTable and any slicers connected to it.
- Apply one simple item filter, then inspect label, value, and date rules separately.
- If results still differ, check source blanks, inconsistent labels, retained items, and worksheet protection.
For example, suppose a sales PivotTable omits orders entered this morning. If the new rows sit below a fixed source range, refreshing alone cannot include them. Extend the source or use an Excel table, then refresh. If the rows are included but the new product is still absent, inspect the product field for another active filter, a spelling difference, or a blank value. Each check addresses a different part of the process.
Frequently Asked Questions
Why is my new data not showing in the PivotTable filter?
Most often, the PivotTable has not been refreshed or its source range excludes the new rows. Refresh it, then check PivotTable Analyze > Change Data Source. A source Excel table can help include future rows, but the PivotTable still needs a refresh.
How do I remove all filters from an Excel PivotTable?
Select a PivotTable cell and choose PivotTable Analyze > Clear > Clear Filters. Check slicers separately, because their selections may need to be cleared from the slicer itself. This does not change or delete source data.
Why does my PivotTable filter show items that are no longer in the data?
The PivotTable may retain old items in its filter cache. Refresh first; if they remain, open PivotTable Options, use the Data tab to set Number of items to retain per field to None, and refresh again.
Why is the filter arrow missing from my PivotTable?
Check whether the field is in the Rows or Columns area, whether the correct cell is selected, and whether the worksheet is protected. A field placed in the Filters area uses a report-filter dropdown above the PivotTable instead of a row-label arrow.
Why does my slicer not filter every PivotTable?
The slicer may not be connected to those reports, or the PivotTables may use incompatible sources. Select the slicer, open Slicer > Report Connections, and check the available PivotTables. Only compatible reports can be connected through that control.
Related
- Excel Keyboard Shortcut for Next Sheet: Ctrl+Page Down
- Excel Keyboard Shortcuts to Find the End of Your Data
- Excel Fill Color Shortcut: Apply Color Quickly
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pivot Table in Excel: Shortcut Keys to Create and RefreshIn Excel for Microsoft 365 on Windows, select a cell in your source data and press Alt+N, V,…
- Excel Pivot Table Custom Filters: How to Use ThemTo add a custom filter to an Excel PivotTable, open the drop-down beside a row or column field,…
- Excel Pivot Chart: Count Unique ValuesYes. An Excel PivotChart can display a count of unique values, but its PivotTable must use the Data…
- Can You Make a Gantt Chart in Google Sheets?Yes. You can make a Gantt chart in Google Sheets by arranging tasks against a row of calendar…
- Can You Make a Stacked Waterfall Chart in Excel?Yes—but Excel does not provide a native chart type that combines stacked components with waterfall steps. In Microsoft…
- How to Make a Flow Chart in Word Online: Step by StepTo make a flow chart in Word Online, open a document, choose Insert > Shapes, draw and label…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.