Others

Fix SharePoint List View Shows 5,000-Item Threshold Exceeded After Filtering

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is encountering a 5,000-item threshold error on a SharePoint list view, even though the applied filter returns far fewer records (around 45).

Product: SharePoint
Device & OS: not provided
Scenario: Attempting to view or filter a SharePoint list containing over 5,000 items.
Observed behavior: The list view displays a threshold exceeded error or 'Access Denied', despite the filter criteria returning a small number of records.

Before you start

Verify your current permissions on the SharePoint site to ensure you have sufficient rights to modify list settings and create column indexes.

Solution 1Recommended

Index Frequently Filtered Columns

Create indexes on the columns used in your filters so SharePoint can quickly retrieve data without scanning the entire list.

SharePoint's list view threshold limits the number of items it can scan in a single query to 5,000 to prevent performance degradation. The threshold applies to the number of items scanned, not the final filtered result. If a column isn't indexed, SharePoint must scan the entire list to find matches. By indexing the column, SharePoint can bypass scanning all items and retrieve the filtered results efficiently.

Access List Settings

Navigate to your SharePoint list and click on the 'Settings' gear icon in the top right corner, then select 'List settings' from the dropdown menu.

Open Indexed Columns

Scroll down to the Columns section and click the 'Indexed columns' link.

Create a New Index

Click 'Create a new index', select the column you frequently use for filtering from the dropdown, and click 'Create'.

Index Creation Limit: You cannot create an index on a list that currently exceeds the 5,000-item limit. You may need to temporarily delete items or use an administrative workaround to reduce the list below 5,000 items before applying the index.

Free Microsoft Office alternative

Switch to WPS Office for a Seamless and Free Productivity Experience

While WPS Office does not directly manage SharePoint server limits, it serves as a lightweight, powerful, and completely free alternative to Microsoft Office. It offers robust document, spreadsheet, and presentation tools that are fully compatible with your existing Office files, helping you work more efficiently.

1. Download WPS Office: Visit the official WPS Office website and click the free download button.
2. Install the application: Run the downloaded installer and follow the on-screen instructions.
3. Open and edit your files: Launch WPS Office and open your existing Microsoft Office files seamlessly.

Highly compatible with Microsoft Excel, Word, and PowerPoint formats.Lightweight software with lower system requirements.Free to use with a familiar, easy-to-navigate user interface.Built-in PDF editing tools for streamlined document management.

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint show a threshold error when my filter only returns a few items?

The 5,000-item limit applies to the number of rows SharePoint has to scan to execute the query, not the final number of items returned. If the column being filtered is unindexed, SharePoint must scan every item in the list, triggering the error if the list has more than 5,000 items.

Can a SharePoint list hold more than 5,000 items?

Yes, a SharePoint list can hold up to 30 million items. The 5,000-item limit is strictly a view and query threshold designed to prevent database performance issues.

What if my list already exceeds 5,000 items and I can't create an index?

If your list is already over the threshold, you cannot create new indexes through the standard UI. You must either temporarily delete items to drop below 5,000, create a new list and migrate data, or use PowerShell (if you have admin rights) to manage the list properties.

Does creating folders help bypass the SharePoint list view threshold?

Folders can help organize data, but viewing a folder that contains more than 5,000 items will still trigger the threshold limit. Proper column indexing and structured views remain the best solution.

Office Quick Solutions