Datasheet view is now called "Quick Edit" in SharePoint 2013. It provides a nice flexible Excel like editor to bulk edit, copy-paste list items and metadata. Similar to a spreadsheet you can create, change and delete items in the grid. As with the new name, quick edit brought many new features in SharePoint 2013, such as:
- You can Edit Managed Metadata columns (Still Rich text columns are not editable in Quick Edit! content type change can't be done from quick edit!!)
- It works just fine in other browsers ( I tested with Firefox and Chrome), where SharePoint 2010 Datasheet view was working ONLY with internet explorer 32 bit version.
- No more Active-X control dependencies. Quick edit doesn't need Office access run time engine now!
- It supports Filters now! Remember the pain of losing filters on datasheet views in those old days?
Quick edit is not working in SharePoint 2013?
In my SharePoint environment, few users having trouble with quick edit. Found Quick Edit button on the "List" tab is disabled (grayed out) with an error message "This control is currently disabled" and "Edit" link missing! How to enable quick edit in SharePoint 2013?
- Check Quick Edit is Enabled: To enable/disable quick edit in SharePoint 2013, you need to navigate to: List Settings >> Advanced settings page >> Scroll down and Under quick edit option, choose "Yes" and then click OK.
- Remove the Group By: If you have grouping enabled in your Views, You got to remove it! If you group list or library items in SharePoint 2013, quick edit (Datasheet View) option is disabled. remove "Group By" selection by setting it to none.
- Change the View style to default: Changing view style to "Shaded", "Newsletter" or something else disables Quick Edit. Change it to "default" in view settings. https://support.microsoft.com/kb/2876824
- Enable 'Allow individual item" check boxes: In view settings make sure, "Allow Individual Items Check boxes" is enabled.
- If you are in datasheet view already- If your current view is "Datasheet view" then quick edit is disabled (obviously!).
- SharePoint View definition XML uses an attribute "<JSLink>clienttemplates.js</JSLink>". During a migration, I had to add this to an existing view using SharePoint designer and verified Quick Edit works as expected.
- Last but not least: Try creating a new view using "Standard View".
You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.