Thursday, December 16, 2010

Fix for SharePoint Datasheet Error: The list cannot be displayed in Datasheet view for one ore more of the following reasons

When I try to open a SharePoint 2010 list in Datasheet View, It scolded me by throwing below error:

The list cannot be displayed in Datasheet view for one ore 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.

The list cannot be displayed in Datasheet view for one ore more of the following reasons - SharePoint Datasheet Error
Or you may face the similar issue:
"The list is displayed in Standard view. It 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 browser does not support ActiveX controls, a component is not properly configured for 32-bit or 64-bit support, or support for ActiveX controls is disabled."
The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons
First, you need to have an Office installation in order to use the datasheet view.

Yes, You may have Ms-Office installed. but the Edit in Datasheet view functionality is not supported if you install 64-bit Office 2010. However, the functionality is available if you install 32-bit Office 2010. The ActiveX control needed for the datasheet view is incompatible with the 64 bit version of Office.

Fix: Install Office 2007/2010 Access Runtime - Data Connectivity Component:

KB: http://support.microsoft.com/kb/2266203



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

1 comment :

  1. Worked perfectly; this was very helpful.

    Thank you!

    ReplyDelete

Please Login and comment to get your questions answered!


You might also like:

Related Posts Plugin for WordPress, Blogger...