This morning i tried to using Datasheet View on company SharePoint portal and got an error message like this picture below :
Don’t worried on this 🙂 This problem caused because we are installing the Ms Office 64 bit :p Until from this article posted and also tried on the SharePoint 2013, the issue still the same. Microsoft not yet decided or having replacement add on for “2007 Office System Driver: Data Connectivity Components” which this component still on platform 32 bit.
So here as below the solution :
- Make sure you are using Internet Explorer with the title 64 bit. Because IE 64 bit does not supporting ActiveX
- You need to install “2007 Office System Driver: Data Connectivity Components” on each client workstation / PC which have a 64 bit version of office installed. This install will put the necessary Active-X components on your workstations to allow SharePoint Datasheets to be used with 64 bit versions of office.
Here is the link you can refer to download the component : http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734