Friday, August 6, 2010

Office 2010 64-bit and the Datasheet View

I’ve just updated my notebook to Office 2010 64-bit, and suddenly, the Datasheet view in my Sharepoint 2010 sites started to give the following error:
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 suport ActiveX controls
- A component is not propelry configured for 32- or 64-bit support.
After wondering what was wrong, I came across this thread.
Apparently, Sharepoint 2010, even being 64-bit, requires the 32-bit ActiveX Datasheet.
Luckily, we can install the 32-bit ActiveX as part of the
“2007 Office System Driver: Data Connectivity Components” that can be downloaded here.

No comments: