Company      |       Articles & Research      |      Services      |      Software      |      Contact

Disable Datasheet View If You Have Super Large Lists In SharePoint 2010

The datasheet view button is available in the Library ribbon tab of the document library can’t be disabled if the list grows beyond the list view threshold. Yet if the list size does exceed the list view threshold the view loads some items. A message will be displayed that tells you there isn’t enough permission to view the entire list. You will be able to disable the datasheet view option from the ribbon in the settings for the list. There is a hard limit of 50,000 items so the view will be blocked if you have any more than that.

share save 171 16 Disable Datasheet View If You Have Super Large Lists In SharePoint 2010

Related posts:

  1. List View Thresholds And Blocked Operations In SharePoint 2010
  2. Designing Large SharePoint 2010 Lists
  3. The List View Threshold In SharePoint 2010
  4. Choosing Between Single And Multiple Lists In SharePoint 2010
  5. SharePoint 2010 Large List Scenarios Best Practices

2 Comments »

  1. Twitter Comment


    Interesting #SP2010 fact – 50k limit on datasheet view: [link to post]

    Posted using Chat Catcher

    Comment by pagalvin (Paul Galvin) — July 10, 2010 @ 7:29 am

  2. Twitter Comment


    RT @pagalvin: Interesting #SP2010 fact – 50k limit on datasheet view: [link to post]

    Posted using Chat Catcher

    Comment by molnaragnes (Agnes Molnar) — July 10, 2010 @ 8:02 am

RSS feed for comments on this post. TrackBack URL

Leave a comment