SharePoint Document Issues

Manage SharePoint Document Libraries Beyond 5,000 Items

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

Question details

Determine how to manage a large SharePoint library when views reach the 5,000-item threshold and lookup filters omit some metadata values.

Product
SharePoint document library
Device & OS
not provided
Scenario
A library contains thousands of documents and folders and uses indexed metadata columns, lookup values, and modern views.
Observed behavior
Some views report a list view threshold error. Removing grouping in a modern view cleared the error, but the Site Name lookup filter does not show every building name, and the existing default view cannot be filtered as expected.
Before you start

Identify the affected view and the columns it filters, sorts, or groups by, especially the Site Name lookup column. Check that you have permission to edit shared views and library settings, or ask your SharePoint administrator to help.

Solution 1Recommended

Simplify the SharePoint library view and use selective filters

Use this approach when a view reaches the threshold because its filtering, sorting, grouping, or lookup operations require too much work.

A SharePoint library can hold up to 30 million files and items, but the 5,000-item list view threshold limits certain operations on a view. Modern experience does not remove that threshold.

An indexed, selective filter can help reduce the items a view must process. Indexing a lookup column alone does not guarantee that a threshold error will be avoided.

1
Open the affected view

Open the document library, select the current view name, and choose Edit current view if available. Alternatively, open Settings > Library settings and select the view under Views.

2
Remove grouping

In the view settings, expand Group By and set the grouping columns to None. Review Sort and remove unnecessary sorting, especially on lookup columns.

3
Check column indexes

In Library settings, open Indexed columns and check whether a suitable, frequently filtered non-lookup column is indexed. Create an index if permitted; index creation can itself be limited in a large library.

4
Apply a selective filter

Return to the view settings and use the Filter section to limit results by an indexed column, such as a relevant status or date. Save the view and test it with the intended users.

Simplify the SharePoint library view and use selective filters
Escalate persistent errors: If a simplified, selectively filtered view still fails, ask your Microsoft 365 administrator to inspect the library and open a Microsoft support request.
Free Microsoft Office alternative

Work with SharePoint documents in WPS Office

WPS Office is a free, lightweight, easy-to-use Microsoft Office alternative with a familiar interface. Download documents from SharePoint and work with compatible Office files in WPS for an easier transition. WPS does not change SharePoint library thresholds or view settings.

Open and edit documents downloaded from a SharePoint libraryCompatible with Microsoft Office formats including DOCX, XLSX, and PPTXFamiliar interface for a smoother move from Microsoft OfficeFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can a SharePoint library contain more than 5,000 documents?

Yes. A library can contain up to 30 million files and items, but individual views and operations can still hit the 5,000-item list view threshold.

Why did removing grouping clear the threshold error?

Grouping can make a view more expensive to process. In the view settings, use Group By to remove grouping, then test the view again; the result depends on the library and other view settings.

Why are some building names missing from the Site Name filter?

The filter pane may not show every lookup value in a large library. Check the Site Name column's source list and permissions in Library settings, then test a separate view with a selective filter.

Why can't I save a filter to the default view?

You may lack permission to edit the shared view, or the view configuration may prevent the intended filter from working. Open the default view under Library settings > Views, or ask a library owner to review its settings and your permissions.