The list cannot be displayed in Datasheet view

SharePoint and office are the most used components when you start working in an office. Almost 90% of our documents are in office compatibility so it’s quite obvious that they have to work with SharePoint without any issues and if you start facing issues then it’s quite annoying!

Environment details:-

·         SharePoint 2010

·         Office 2013

·         Windows Server 2008 R2

Here is the error message that I am talking about:

The list cannot be displayed in Datasheet view for one or more of the following reasons:

- A datasheet component compatible with Microsoft SharePoint Foundation is not installed.

- Your Web browser does not support ActiveX controls.

- A component is not properly configured for 32-bit or 64-bit support.

Resolution:

To resolve this you need the following data connectivity component installed: http://www.microsoft.com/en-us/download/details.aspx?id=23734

 Although this says 2007 and therefore looks like an odd install in relation to 2010 SharePoint it resolves this data sheet issue.

Imp Notes:

The Edit in Datasheet view functionality in SharePoint Server 2010 is not supported if you install 64-bit Office 2013 client. The Edit in Datasheet functionality is available if you install 32-bit Office 2013 client.

Reference:

·         http://technet.microsoft.com/en-us/library/ee681792.aspx

·         http://office.microsoft.com/en-us/sharepoint-foundation-help/use-datasheet-view-in-64-bit-office-2010-HA101882420.aspx

If you have any queries / questions then please let me know. I would be more than

happy to help you as well as resolves your issues, Thank you!