SharePoint Document Issues

How to Remove Incorrect Values from a SharePoint List Filter Pane

John WilsonJohn Wilson Nov 4, 2026 868 views

Question details

The user needs to clean up stale or outdated values that continue to appear in a SharePoint Online list filter pane.

How to Remove Incorrect Values from a SharePoint List Filter Pane
Product
SharePoint Online
Device & OS
not provided
Scenario
When filtering a SharePoint list by a specific category (e.g., City), outdated lookup or choice options (e.g., old Street or Property names) still appear in the filter pane.
Observed behavior
Selecting the incorrect or outdated filter values returns an empty list, indicating the data comes from stale list items, old lookup sources, or unupdated choice configurations.
Before you start

Ensure you have 'Edit' or 'Full Control' permissions for the SharePoint list to modify column settings and access underlying lookup source lists.

Solution 1Recommended

Review and Update Column Configurations

Identify the source of the incorrect values by checking the affected column's settings and removing obsolete choices or lookup items.

Filter values in SharePoint are typically populated directly from the column's configuration (for Choice columns) or an external source list (for Lookup columns). Modifying these configurations resolves the root cause of stale filter data.

1
Access List Settings

Navigate to your SharePoint list, click the Gear icon (Settings) in the top right corner, and select 'List settings'.

2
Edit the Affected Column

Scroll down to the 'Columns' section and click on the name of the column displaying incorrect values in the filter pane.

3
Remove Stale Choices

If the column type is 'Choice', locate the text box containing each choice on a separate line. Delete the incorrect or outdated values and click 'OK' to save.

4
Update Lookup Source

If the column is a 'Lookup' type, note the source list it points to. Navigate to that specific source list and delete or correct the obsolete items there.

Review and Update Column Configurations
Refresh Delay: After updating lookup lists or column choices, it may take a few minutes for the filter pane to reflect the changes due to SharePoint's search indexing schedule.
Free Microsoft Office alternative

Manage Your Exported List Data Efficiently with WPS Office

While SharePoint handles complex list management, analyzing and filtering the exported data locally can be demanding. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for processing your exported SharePoint lists.

  1. 1. Export List Data from SharePoint: In your SharePoint list, click 'Export' and select 'Export to Excel' to download your list data as a compatible spreadsheet file.
  2. 2. Open Data in WPS Office: Launch WPS Office and drag your downloaded Excel or CSV file into the WPS Spreadsheet workspace.
  3. 3. Filter and Clean Data: Use the Data Filter tools in WPS Spreadsheet to rapidly identify, sort, and clean up any stale or incorrect values offline.
Fully compatible with Microsoft Excel (.xlsx) and CSV formats exported directly from SharePoint.Free, lightweight suite for seamless spreadsheet, document, and presentation management.Familiar tabbed user interface, ensuring a smooth transition with zero learning curve.Advanced built-in data filtering and cleanup tools to identify stale values instantly.
microsoft office alternative - wps office

Frequently Asked Questions

Why do deleted items still show up in my SharePoint list filter pane?

Deleted items may still appear in the filter pane due to search index caching delays, or because the values are hardcoded in a Choice column's settings rather than dynamically pulled from the list data. You must manually delete them from the column settings or wait for the search index to crawl the list.

How do I remove an old value from a SharePoint Lookup column filter?

You cannot edit a lookup column's options directly from the destination list settings. You must identify and navigate to the source list that the lookup column references, then delete or modify the incorrect item directly within that source list.

How long does it take for a reindexed SharePoint list to update the filter pane?

Reindexing a list places it in a queue for the SharePoint search crawler. Depending on your organization's server load and Office 365 environment, it can take anywhere from a few minutes to several hours for the changes to fully reflect in the filter pane.