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.
A 64-bit version of the Datasheet component is not available for Office 2010.
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:
2007 Office System Driver: Data Connectivity Components
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"
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.