"The number of items in this list exceeds the list view threshold, which is 5000 items" error when you view a SharePoint Online list in Office 365 for enterprises pre-upgrade

Article translations Article translations
Article ID: 2759051 - View products that this article applies to.

Not sure what release of Office 365 you're using? Go to the following Microsoft website:
Am I using Office 365 after the service upgrade?
Expand all | Collapse all


When you view a Microsoft SharePoint Online list in Microsoft Office 365 for enterprises pre-upgrade, 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.


To work around this issue, split the items into multiple lists so that no list exceeds 5,000 items. Because you'll be unable to view the list items beyond the limit of 5,000 items, you must configure metadata-based navigation so that you can access all the list's contents.

To enable metadata-based navigation, follow the "Enable Metadata Navigation and Filtering" and "Configure Metadata Navigation" sections of the following Microsoft website:
Configure metadata navigation for a list or library
After metadata navigation is enabled, the list's contents will become available. We recommended that you then reduce the list's contents to less than 5,000 items.


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.

For more information about how to manage lists and libraries that contain many items, go to the following Microsoft website:
Manage lists and libraries with many items

Still need help? Go to the Office 365 Community website.


Article ID: 2759051 - Last Review: February 27, 2013 - Revision: 3.0
Applies to
  • Microsoft Office 365 for enterprises (pre-upgrade)
  • Microsoft Office 365 for education  (pre-upgrade)
  • Microsoft SharePoint Online
o365 o365e o365a o365062011 pre-upgrade KB2759051

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com