List View Threshold feature was created to set limits on how severely users can put the beat down on your servers. The List throttling states that you cannot have more than 5,000 items (by default) returned in your list view. When the list view threshold is reached in a particular list or library, users will see the friendly error message “This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator”
Change the List View Threshold Limit in SharePoint on-premise
For on-premise SharePoint, we can easily change this limit through sharCentral Administration but it is not recommended unless you are 100% sure that it will not negatively affect your system.
- Login into Central Administration
- Go to Application Management -> Manage Web Applications
- Select the Web application for which you want to change the LVT.
- In the ribbon above, click General Settings. That will bring down a menu, from which you select Resource Throttling
- Change the List View Threshold to another value and click OK
Change the List View Threshold Limit in SharePoint Online
For SharePoint Online, the list view threshold is 5,000 which cannot be modified.
To work around this issue, review the recommendations, techniques, and tips outlined in the “Ways to manage lists and libraries with many items” section of the “Manage lists and libraries with many items” guidance located at the following Microsoft website: Manage lists and libraries with many items
You can also checkout this thread: https://community.office365.com/en-us/f/148/t/79787
Advertisement