Monthly Archives: June 2012

The list cannot be displayed in Datasheet view

19 Tuesday Jun 2012

Posted by in SharePoint 2010

≈ 1 Comment

Tags

, , , , ,


You cannot view a list in Datasheet view on a SharePoint website after you install the 64-bit version of Microsoft Office 2010.

When you click Actions and then click Edit in Datasheet on a SharePoint 2003 or 2007, or you click the List tab and then click Datasheet view on a SharePoint 2010 site, you receive the following error message:

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.

The reason is a 64-bit version of the Datasheet component is not available for Office 2010.

To Fix this:

You can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. These components are available from the Microsoft download center:

The 2007 Office System Driver: Data Connectivity Components installs a 32-bit version of the Datasheet component that will work with the 64-bit version of Office 2010 as long as you are using a 32-bit version of an Internet browser.

Click here to view or hide more information about “2007 Office System Driver: Data Connectivity Components”

Reference: http://support.microsoft.com/kb/2266203