If you have installed the 64-bit new version of Microsoft Office, Office 2010, then you will most likely see the following message when trying to edit a SharePoint list using the Edit in datasheet function:
The list cannot be displayed in Datasheet view for one or more of the following reasons:
– A datasheet component compatible with Windows SharePoint Services is not installed.
– Your Web browser does not support ActiveX controls
– Support for AxtiveX controls is disabled
The issue revolves around the fact that 64-bit versions of Office 2010 do not ship with the 32-bit Activex control that would make the datasheet option work with Internet Explorer.
There are ways to make this work, and the usual suggestion is to find a copy of an Office 2007 product and either install it (such as SharePoint Designer 2007) or just choose to install the Windows SharePoint Services components of the product. This works, but I don't really want to go to that much trouble.
Another solution, and the one that I employed, is to install the 2007 Office System Driver: Data Connectivity Components. After installing the Components, go back to the menu and the datasheet option will work great.
4 Comments
Anonymous
Thanks!!! Works great.
COlivier
This is great information, thanks. You saved me a reinstall of Office.
Anonymous
Works like a charm!!
tanks
Anonymous
It worked! thank you!