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. https://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

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

Leave a Reply

Your email address will not be published.