Article ID: 2266203 - View products that this article applies to.
Expand all | Collapse all

Symptoms

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 site, 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.

Cause

A 64-bit version of the Datasheet component is not available for Office 2010.

Resolution

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"

Workaround

If your business needs do not require you to use the 64-bit version of Office 2010, we recommend that you uninstall the 64-bit version of Office 2010 and install the 32-bit version of Office 2010. A 32-bit version of the Datasheet component is installed with the 32-bit version of Office 2010.

For more information about the issues with the 64-bit version of Office 2010, please see the following articles.
64-bit editions of Office 2010
Understanding 64-bit Office

Properties

Article ID: 2266203 - Last Review: November 5, 2012 - Revision: 12.0
Applies to
  • Microsoft Office Professional 2010
  • Microsoft Office Professional Plus 2010
  • Microsoft SharePoint Foundation 2010
  • Microsoft SharePoint Server 2010
  • Microsoft Office SharePoint Server 2007
  • Microsoft Windows SharePoint Services 3.0
  • Microsoft Windows SharePoint Services 2.0
  • Microsoft Office SharePoint Portal Server 2003
  • Microsoft Office 365 for enterprises
  • Microsoft Office 365 for small businesses
  • Microsoft Office Professional 2013
  • Microsoft Office Home and Business 2013
  • Microsoft Office Home and Student 2013
  • Microsoft Office Professional Plus 2013
  • Microsoft Office Standard 2013
  • Microsoft Office Professional Academic 2013
  • Microsoft SharePoint Server 2013
  • Microsoft SharePoint Foundation 2013
Keywords: 
kbprb kbsurveynew kbpubtypekc kbinstallation vkbportal231 vkbportal237 o365 bposs kbcip KB2266203

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com