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:
Note that if you’re on a shared hosting plan, then this option is not available for you.
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.
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.
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.
At PortalFront we provide fully managed SharePoint services and support. You may contact us via this form to get a free consultation.