The List is displayed in standard view. It can't be displayed .....

The List is displayed in standard view. It can't 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.

Observation: I have seen that most of the users face this kind of issue if they are using Internet Explorer 6.0 (IE 6)

1. Windows SharePoint Service Support options for Microsoft Office should be installed (applicable for Office 2007 as well as for Office 2010)

How to enable this option:


-Start-Control Panel-Add or Remove Programs-click on Microsoft Office and then Change
-Add/Remove Features


-Expand the Office Tools category.


-Next verify that you have both the Microsoft Office Access Web Datasheet Component and the Windows SharePoint Services Support component installed.


-If these components are not installed choose to run them from your computer and then click the Continue button and go through the installation process. You may need your Office 2007 install media.

2. Next you want to verify that you can run ActiveX controls in Internet Explorer. To do this open IE and go to the Tools menu > Internet options


3. Next click on the Security tab and for your Trusted sites click (choose Internet if you do not add your SharePoint sites to your Trusted Sites) on the Custom level button


4. Verify that you can use previously unused ActiveX controls.


5. Verify that you can download signed ActiveX controls and that you can run ActiveX controls and plug-ins.


6. The next setting is –> select "Enable" for Script ActiveX controls marked safe for scripting.


7. Adjust these settings accordingly and then click OK twice to return to Internet Explorer.


8. You may need to close Internet Explorer and re-open the program before your new settings take hold and become active.