By default, the Datasheet view of a list or library is not supported when you are using the 64-bit version of Microsoft Office 2010 installed on a 64-bit Windows operating system.
If you want to use Datasheet view, we recommend that you install the 32-bit version of Microsoft Office on a 64-bit Windows operating system.
If your business needs require using the 64-bit version of Office 2010, you can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. These components are available here on the Microsoft download center:
Find out if your Office is 32- or 64-bit
To find the bit version of Microsoft Office 2010, on the File tab, Click Help, and then note the bit version under the About section.
Find more information about 64-bit Office 2010 in the See Also section.
The 2007 Office System Driver: Data Connectivity Components install 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.
IMPORTANT If you are using a 64-bit version of an Internet browser, for example the 64-bit version of Microsoft Internet Explorer 8.0, there is no support for the Edit in Datasheet feature.
You must install all 64-bit versions of Office products before you install the 2007 Office System Driver: Data Connectivity Components.
For example, if you plan to install Microsoft Project 2010, Microsoft Visio 2010, or Microsoft SharePoint Designer 2010, components that are not installed as part of an Office 2010 suite, you must install the 64-bit versions of these products before you install the Data Connectivity Components.
Other reasons Datasheet view might not work
There might be other reasons why Datasheet view is not working, including the following:
- A datasheet component compatible with SharePoint 2010 is not installed.
- Your browser does not support ActiveX controls.
- Certain libraries and lists do not support Datasheet view, such as a slide library, and therefore the Datasheet view command is dimmed.
It WILL open in Datasheet View