22 June, 2012

Edit in datasheet is missing in SharePoint 2010

SharePoint 2010 is simply fabulous J this version has already comes up with lot of new enhancements and easy to use functionality.
Requirements: Let’s suppose the site collection administrator has decided that he doesn’t want his team members to see the option of ‘edit in datasheet’ for a specific library. If I want to reframe this information in other terms then it would be like this-Site collection administrator wants to hide the ‘edit in datasheet’ option for a document library so that nobody can open it in datasheet view/ nobody can download the data by means of datasheet view.
In sharepoint 2007, it was possible by using some customized coding but in SharePoint 2010, it an out of box functionality and can be easily achieved.
Resolution: Please refer the following steps and your issue will be resolved:
·         Open the document in which you are facing the problem
·         Settings
·         Document library settings
·         Advanced settings
·         Make this option-“Allow items in this document library to be edited using the datasheet?”- Yes
·         Click OK
That’s it and you are done J
Note: it requires full control permissions for the document library or at the site level so that you can see the settings option.
If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues J J
Thank you.


  1. Calendar

    <%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages"
    Assembly="Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

    <%@ Register TagPrefix="CustomCalnderView" Namespace="InnoCERT.Utilities" Assembly="InnoCERT.Utilities,

    Version=, Culture=neutral, PublicKeyToken=2cc1cd5895a3a606" %>


Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge