"The number of items in this list exceeds the list view threshold" error when you view a SharePoint Online list in Office 365 Enterprise

Problem

When you view a SharePoint Online list in Office 365 Enterprise, you receive the following error message:

  • 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.

Solution

To work around this issue, review the recommendations, techniques, and tips outlined in Manage large lists and libraries in SharePoint.

More information

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.
 
Still need help? Go to Microsoft Community.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×