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!

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!