Excel Table Filter Not Updating? Fix It Step by Step

Errors & fixes · Updated November 19, 2026

If an Excel table filter is not updating, first choose Data > Reapply to refresh the current filter and sort, then check that the new or changed rows are actually inside the table. If the results are still wrong, clear the affected column’s filter and apply it again; a stale filter, an undersized table, or a formula that has not recalculated can each look like the same problem.

What “not updating” can mean

People use this phrase for several different behaviors. You may have added a record and not see it in the table, changed a value but still see the row under a filter that should exclude it, or opened a filter menu whose checklist appears to omit a value. Sorting can also seem stale: Excel does not necessarily move a row to a new position just because a value in the sort column changed.

These cases have different fixes. A row outside the table is not included in the table’s filter at all. A filter criterion can leave rows hidden even after the underlying values change. A formula may still be showing an old result because calculation is set to manual. A sort order, meanwhile, is a separate operation from filtering. Identifying which behavior you see prevents unnecessary edits to the workbook.

First click a cell in the table and look for the filter arrows in the header row. Then check whether the missing record is inside the banded table area, whether any filter icon indicates an active filter, and whether the cell value is what you expect. These quick checks usually narrow down the cause before you change any settings.

Check that the data is inside the Excel table

An Excel table filters only its own range. Typing immediately below a table often expands it automatically, but data imported, pasted, or placed several rows away may sit outside the range. It can look like part of the same dataset while being excluded from the table’s filter.

  1. Click a cell in the table and inspect the table boundary. New records should be within the formatted table area, not merely beneath it.
  2. Select Table Design > Resize Table. Review the range shown in the dialog and extend it to include the missing rows or columns if needed.
  3. Alternatively, click in the first cell below the table and enter data there, then confirm that the table expands to include the new row. Check the boundary rather than assuming expansion occurred.

The Table Design tab appears when a table cell is selected. If the tab is absent, the data may only be a formatted range, not an Excel table. You can create a table by selecting the data and choosing Insert > Table, then confirming whether the first row contains headers. Creating a table is not required to use AutoFilter, but it gives the range table-specific behavior and makes its boundaries easier to inspect.

Check the header row as well. Each column should have a distinct, nonblank header. Blank or duplicate headings can make filter menus confusing, particularly after importing data. Also look for a completely blank row or column between the existing table and new data: that gap can prevent Excel from recognizing the new records as a continuation.

Reapply or clear the filter

When the table range is correct but its visible rows do not match the current values, reapply the filter. In Excel for Microsoft 365 on Windows, select Data > Reapply. The command reapplies the current filter and sort criteria to the data; it does not remove the criteria or add rows that are outside the table.

If that does not work, open the dropdown on the affected column. Choose Clear Filter From followed by the column name, or select all the relevant values in the checklist and apply the filter again. To remove all filters from the table, use Data > Clear. Clearing a filter makes rows visible again; it does not delete data. After clearing, open the dropdown and set the condition you actually want.

  • A value is missing from the checklist: confirm that a cell in the table contains that exact value, then reapply or reopen the dropdown. Look for extra spaces or a different spelling.
  • A changed row remains visible: clear and reapply that column’s filter so Excel evaluates the current value against the selected criteria.
  • Rows seem to vanish: check every column for an active filter. Multiple filters work together, so a row must meet all active conditions to remain visible.

Filtering hides rows; it does not erase them. To confirm whether records are hidden, clear the filters and inspect the table again. If a filter arrow shows a funnel icon rather than only a dropdown arrow, that column has a filter in effect.

Check values, spaces, and data types

Two entries that look alike on screen may not be identical to Excel. For example, “North” and “North ” differ because the second value has a trailing space. A nonbreaking space copied from a webpage can also be difficult to spot. If the filter checklist contains near-duplicates, inspect the source cells and standardize the data before relying on the filter.

Numbers and dates can also be stored inconsistently. One row may contain a true date value while another contains text that looks like a date. A numeric-looking value may be text in some rows and a number in others. This can affect how the dropdown groups values or offers filtering choices. Check the cell format and the actual stored value, not just its appearance. If the data came from a CSV or external system, inconsistent types are especially worth checking.

For a text condition, check whether the filter is set to an exact selection or a rule such as Text Filters. For numbers or dates, inspect Number Filters or the available date options. A criterion such as “greater than” can continue to exclude a newly added value even though the dropdown itself is functioning correctly. Reopening the menu and reviewing the active condition often explains an unexpected result.

When formulas are involved

If the filtered column contains formulas, make sure the formulas have recalculated before judging the filter. In Excel, select Formulas > Calculation Options > Automatic if the workbook is set to manual calculation. You can also press F9 to calculate open workbooks. On a Mac, use the same Formulas menu; keyboard shortcuts can differ by keyboard and Excel version.

For example, a formula may display “Open” based on another cell. If the input changes but the workbook is not recalculating, the displayed result can remain “Open,” and a filter for “Closed” will not show that row. Recalculating updates the formula result; then use Data > Reapply if the visible rows still do not reflect the updated result.

Do not confuse a table filter with a dynamic-array formula. A filter hides or shows rows in a range. Functions such as FILTER, available in Microsoft 365 and Excel 2021 or later, return results in a separate spill range and have their own recalculation and spill behavior. If you are looking at formula-generated output rather than the original table, check the formula and its source range separately.

Filtering and sorting are different

A filter decides which records are visible; a sort changes their order. If a value in a sorted column changes, the row may not jump to its new position until you sort or reapply the sort. Choose Data > Reapply to reapply the active sort and filters, or use the column’s sort options to sort again. Reapplying does not change the sort direction or filter conditions you chose.

When results seem incomplete, check whether a sort has simply moved the record elsewhere in the table. When rows are absent, inspect the filters. You can have several active filters at once—for example, a region filter and a date filter—and Excel shows only records that satisfy all of them. Clearing one column’s filter can reveal rows that were excluded by that condition without disturbing the other columns’ filters.

Excel for Windows, Mac, and the web

The core checks are similar in Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web: confirm the table range, inspect active filter criteria, and reapply or clear filters. On Windows, use the ribbon path Data > Reapply. On Mac and in the web app, look for the Reapply command on the Data tab; ribbon layout and available keyboard shortcuts can vary. If you cannot find it, clearing and setting the affected column’s filter again is a practical alternative.

To resize a table, select a cell in it and use Table Design > Resize Table in desktop Excel for Windows. In Mac or web versions, the tab name or placement may differ, so inspect the table-related ribbon controls. Avoid relying on a Windows shortcut if you are on another platform; use the visible ribbon command instead. If a workbook is open in a browser and the controls are limited, open it in the desktop app for the table-specific commands available there.

Prevent the problem in future workbooks

A few habits make filters more dependable, especially in a workbook that receives regular updates:

  • Keep one clear header row, with a unique name for each column and no merged header cells.
  • Add new records directly below the table and verify that the table boundary expands. Resize the table if an import or paste did not extend it.
  • Use consistent date, number, and text formats within each column. Clean imported spaces and inconsistent labels when they affect grouping.
  • Before sharing a filtered workbook, consider clearing filters if readers need to see every record. A saved filter can make a complete dataset look incomplete.
  • When a result looks stale, check the source value and calculation mode before rebuilding the table or deleting rows.

These practices are more reliable than repeatedly toggling filter arrows. Turning filtering off and on can restore a visible list, but it will not correct an incorrect table range, inconsistent source values, or a formula that has not recalculated.

Frequently Asked Questions

How do I refresh an Excel table filter?
Select a cell in the table and choose Data > Reapply. If the results remain wrong, clear the affected column’s filter and set it again.

Why are new rows not included in my Excel filter?
The rows may be outside the table range. Select a table cell, choose Table Design > Resize Table, and confirm that the range includes the new records.

Why does a filter still show a row after I changed its value?
The current filter may not have been reapplied to the changed value. Choose Data > Reapply, or clear and reset that column’s filter. Also check whether a formula in the cell has recalculated.

Does clearing a filter delete hidden rows?
No. Clearing a filter makes the hidden rows visible again; it does not delete records. Check the filter icon or use Data > Clear to remove filters.

Why does the filter dropdown show duplicate-looking values?
The source cells may contain extra spaces, different spellings, or values stored as different types. Inspect and standardize the underlying data, then reapply the filter.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.