SharePoint 2013 Quick Edit Bug when editing more than 30 documents

SharePoint 2013 introduces a new ‘Quick Edit’ function to replace the use of Datasheet views that was present in SharePoint 2010. Crystal posted two excellent blogs containing things to know about SharePoint 2013 Quick Edit, which you can find here:

http://www.boostsolutions.com/blog/things-to-know-about-sharepoint-2013-quick-edit-part-1/
http://www.boostsolutions.com/blog/things-know-sharepoint-2013-quick-edit-part-2/

A customer of ours uses this functionality for bulk editing new metadata columns when migrating content from their previous Intranet. One document library would contain several hundred items, which meant they exceeded the page item limit and would get multiple pages to browse through. As soon as they clicked to continue on to the second page, the quick edit mode would break. The quick edit was still enabled, but when clicking on any cell it would be greyed out, rather than have the blue highlight around it. This can be seen in the image below:

Image

Finding out what caused this strange bug took quite some time, so that’s why I’m sharing it with the world. We went through the different contenttypes and their fields to figure out if one of those was the source of the issue. That wasn’t the case. Then we checked if versioning had anything to do with it. Again – not the issue. In the end it turned out to be the presence of the default SharePoint Field ‘Edit (linked to edit item)’ in the view. As soon as we removed this field from the view, bulk editing meta data through several pages was no longer an issue:

Image

So in summary, if you experience issues where the quick edit fields are greyed out when browsing through a multi-paged document library, be sure that the field ‘Edit (linked to edit item)’ is not present in the current view. Gotcha!

Advertisements