The list cannot be displayed in Datasheet view

This morning i tried to using Datasheet View on company SharePoint portal and got an error message like this picture below :

SharePoint-Error-Datasheet_thumb

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 :

  1. Make sure you are using Internet Explorer with the title 64 bit. Because IE 64 bit does not supporting ActiveX
  2. 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

Happy Sharepoint-Ing

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.