Fix SharePoint 2010 Datasheet View is Disabled Issue

Problem:
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

Solution:

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.

E.g. http://sharepoint.crescent.com/credit/Lists/pipeline/RptAll.aspx?View={74EA6C44-C956-4B7F-8EB5-48C92EB6D7AB}&ShowInGrid=True

This activates datasheet view for any list in SharePoint 2010!

sharepoint 2010 edit in datasheet greyed out

Salaudeen Rajack

Information Technology Professional with Two decades of SharePoint Experience.

Leave a Reply