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.

  1. Navigate to Central Administration. You can get to it by going to the SharePoint server and searching for "Central Administration" under the start menu.
  2. Go to Application Management > Manage Web Application and click on your web application to select it.
  3. In the Ribbon, click on General Settings drop down and choose "Resource Throttling".
  4. In the "List View Threshold", increase the value by 2 fold and click OK.
  5. 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.

  1. Go the list settings
  2. Click on the column "Indexed Columns"

  3. Click on Create a new Index
  4. Under primary column select the column you want.
  5. 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

    5k limit is not removed in sp2016 and in office 365 you can not change it…

  • http://www.portalfronthosting.com Karim Roumani

    Amit, you are right on both.

    In O365 – Your only option is Option 2, which is to create the indexes.

    In SP 2016 – The limit is still there in the web app. They did improve the locks and create auto indexes.

    Here’s more on that: http://blogs.technet.com/b/wbaer/archive/2015/08/27/navigating-list-view-thresholds-in-sharepoint-server-2016-it-preview.aspx

    Thanks for pointing this out.

  • Jason Rohde

    One given solution is to index columns. Indexing columns is the operation that won’t run because of the exceeded threshold. Can I get around this without increasing the threshold?

  • Eric J.

    I’m also hitting the issue when I try to index columns.

  • Karim Roumani

    Are you on O365 or sharepoint on premises?

  • Eric J.

    2013 On Prem

  • Karim Roumani

    Did you try solution 1 above? that one will work for sure usually.