Video: SharePoint lists V - Techniques for managing large lists

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

When a SharePoint list gets large, you might see warnings such as, “This list exceeds the list view threshold,” or “Displaying the newest results below.” Find out why these warnings occur, and learn ways to configure your large list so that it still provides useful information.


After completing this course you will be able to:

  • Learn what the List View Threshold is, and understand its benefits.

  • Create an index so that you can see more information in a view.

  • Create folders to better organize your large list.

  • Use Datasheet view for fast filtering and sorting of a large list.

  • Learn what the Daily Time Window for Large Queries is.

  • Use Key Filters for fast filtering within Standard view.

  • Sync a large list to SharePoint Workspace.

  • Export a large list to Excel.

  • Link a large list in Access.

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.