Can we increase list view threshold in SharePoint Online which is 5000 by default?

6 Answers 6


No, Its not possible to change the list item threshold value, What happens if you have 5001 items? This little gem of an error pops up: "The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited." In a nutshell, you will not be able to upload more items until you go below the threshold.

The official reason listed by Microsoft is: "This issue occurs because SharePoint Online uses the Large List Resource Throttling feature. By default, the list view threshold is configured at 5,000 items. When the defined item limit in a list is exceeded, the message is displayed."

This is one of the key difference between O365 and On Premise SharePoint. With On Premise SP, you can actually increase the threshold limit and get around that error, but it does have a consequence as your SQL Server will take a significant resource hit.

Why is 5,000 such a magic number? To minimize database contention, SQL Server often uses row-level locking as a strategy to ensure accurate updates without adversely impacting other users who are accessing other rows. However, if a read or write database operation, such as a query, causes more than 5,000 rows to be locked at once, then it's more efficient for SQL Server to temporarily escalate the lock to the entire table until the database operation is completed. When this lock escalation occurs, it prevents other users from accessing the table. If this happens too often, then users will experience a degradation of system performance. Therefore, thresholds and limits are essential to help minimize the impact of resource-intensive database operations and balance the needs of all users.

As I alluded to earlier, you will not be able to delete the list and/or the site unless you manually delete the items first. The problem is that once you exceed the limit, the items will not render at all. You are just left with an error message and no visible way to get to your data.

To overcome this, you can follow the links provided by @BhaskarDhone


  • 2
    "you will not be able to upload more items until you go below the threshold". I agree limitation will appear above 5000 items but you can have more than 5000 items in a list. Jan 14, 2016 at 7:41

Increasing the List View Threshold in SharePoint Online is not permitted.

This article has some suggestions for working around the LVT - http://www.markrackley.net/2014/10/22/working-around-that-pesky-list-view-threshold-in-office-365-sharepoint-2013/


In SharePoint online list view threshold can not be modified. As answered by Erik.

Sharing two workaround that may help you out :

  1. You can splits the items into multiple list so that no lists exceed 5000 threshold. Reference

  2. Create more views and sync the items to different views. Below links will help you to achieve.

Create, modify, or delete a view

Manage lists and libraries with many items


No possibility to increase threshold in SharePoint online..we can add items up to 60 million in single list , if we set item limit in view it displays all items in paging , item limit per page is 5000. list have 25000 items if we set item count 2000 then it displays 13 pages. By coding csom we need get items by using item position in caml.


We created a JS solution to pre-filter a list query and retrieve data in chunks. We described the used technique here:


We are interessed in your thoughts!

  • Can I drop this code into a Script Editor WP as is or do I need to put my own values in?
    – TheJDScott
    Mar 2, 2020 at 15:37

You can increase the items displayed per page by navigating to Library > Manage Views > Modify View > Item Limit

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.