DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2266203 - Last Review: October 4, 2014 - Revision: 14.0

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 (http://technet.microsoft.com/en-us/library/ee681792.aspx)
Understanding 64-bit Office (http://blogs.technet.com/b/office2010/archive/2010/02/23/understanding-64-bit-office.aspx)

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 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: 
kbsurveynew kbpubtypekc kbinstallation vkbportal231 vkbportal237 o365 kbcip o365e o365p o365a o365m o365022013 KB2266203
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support