Fix SharePoint 2010 Datasheet View is Disabled Issue

SharePoint datasheet view is a quick nifty way to update metadata on multiple items at once. Unfortunately, some of the list and libraries such as picture libraries in SharePoint 2010 doesn’t provide datasheet view!

sharepoint datasheet disabled


So, How to get datasheet view on SharePoint picture libraries? Well, here in the workaround!

How to Get Datasheet view for any List view in SharePoint?
To get datasheet on any list view, Just append “&ShowInGrid=True” parameter to the URL.


This activates datasheet view for any list in SharePoint 2010!

sharepoint 2010 edit in datasheet greyed out

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

Leave a Reply