Whats up with SharePoint List message “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator”
This is covers a common issue many face when they have many items in their list.
What you may experience:
You try to view the contents of a SharePoint list and this message appears.
The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator
If you navigate to the list settings page you get:
Solution 1: Changing the limit in Central Administration
Note that if you’re on a shared hosting plan, then this option is not available for you.
- Navigate to Central Administration. You can get to it by going to the SharePoint server and searching for "Central Administration" under the start menu.
- Go to Application Management > Manage Web Application and click on your web application to select it.
- In the Ribbon, click on General Settings drop down and choose "Resource Throttling".
- In the "List View Threshold", increase the value by 2 fold and click OK.
- Check the list now. Keep increasing the threshold if the error persists.
Solution 2: Add indexes to columns
In your view find out what the view if filtering or sorting on. Lets say it is sorting by category and filtering by status, then both those fields need to be indexed. It’s very easy to add something a column to the index.
- Go the list settings
-
Click on the column "Indexed Columns"
- Click on Create a new Index
- Under primary column select the column you want.
-
Click Create
You’re done
Now try going back to your view and check to see if the list loads. If it doesn’t make sure all the needed column are indexed.
What About SharePoint 2016?
There is some really good news on this topic. The issue with the listview threshold of 5000 is something that SharePoint 2016 will resolve on its own. This limit will not be an issue in this version. SharePoint 2016 will not be release until 2016.
-
Amit Lohogaonkar
-
http://www.portalfronthosting.com Karim Roumani
-
Jason Rohde
-
Eric J.
-
Karim Roumani
-
Eric J.
-
Karim Roumani