Earlier today my coworker attempted to edit a SharePoint list in data sheet view, something they had done many times previously. However, even though they could click on the 'Datasheet' button, they were unable to actually edit in datasheet view, the view kept going back over to the standard view in SharePoint. Some quick internet searching didn't return many articles, but I recalled a similar issue with 64-bit office users in the past… So what was the issue? They happened to be running Office 2013, which doesn't ship with the necessary Data Connectivity Components (read: ActiveX DLLS) to use SharePoint 2010's data sheet editor. Some other typical complaints you may receive from users experiencing a similar issue would be:
- Datasheet view doesn't work on Windows 8.
- Datasheet view doesn't work with 64-bit IE.
- Datasheet view seems broken on SharePoint 2010 with Office 2013.
Happily, Microsoft has a really easy fix called: 2007 Office System Driver: Data Connectivity Components. Simply download this 25MB package from Microsoft (here: http://www.microsoft.com/en-us/download/details.aspx?id=23734), ensure you're using a 32-bit version of Internet Explorer, and you'll be all good to go!