Display a list in Datasheet view. Datasheet view requires that you have a Windows SharePoint Services-compatible datasheet program installed, such as Microsoft Office 2010 Professional. Datasheet view lets you add, delete, and update list entries just as you would in a spreadsheet program, such as Microsoft Office Excel 2010. Come across such issue that belongs to datasheet view and details are as follows:
As we all know that SharePoint list consist of two views by default: Standard view and datasheet view. The standerd view is working fine without any issues but when i changed the view from standerd view to datasheet view then i faced the below mentioned problem | 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.
Configuration:-
-Machine OS: Windows 7 (64 bit)
-Office installed: Office 2010 (64 bit)
-IE version: IE8.0
Resolution:
Issue has been resolved because of this post
You can solve the issue by installing the “2007 Office System Driver: Data Connectivity Components” downloadable under:http://www.microsoft.com/download/en/confirmation.aspx?displaylang=en&id=23734
Why this issue occurs:
The ActiveX control for the Datasheet view is not compatible with Office 64-bit versions.
what is imporant to note:
Microsoft strongly recommends the use of 32-bit (x86) versions of Office 2010, Project 2010, and Visio 2010 applications as the default option for all platforms.
Office 2010 64 bits will not be required in most of the scenarios.
Note: DataSheet is an ActiveX control so it would work with only Internet Explorer.
I hope the above mentioned information is pretty much clear to resolve the issue but still in case of any doubts/queries/questions then please let me know.
I would be more than happy to help you as well as resolves your issues, Thank you
