There is no one Solution to this issue . I have found that it may happen due to various reasons .
"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 Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled"
Resolution :
* Try clearing the IE cache .it may workout to be the best and quick solution
* Try Doing a Repair of Office . or reinstall
* Windows SharePoint Service Support options for Microsoft Office should be installed (applicable for Office 2003 as well as for Office 2007)
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.
* Check if ActiveX controls are active in Internet Explorer.
To do this open IE and go to the Tools menu > Internet options
* Select "Enable" for Script ActiveX controls marked safe for scripting.
* Adjust these settings accordingly and then click OK twice to return to Internet Explorer.
If you are running Internet Explorer 9 (32 and 64-bit are installed at the same time) use the 32-bit version. SharePoint doesn’t like using datasheet view if you are running IE9 on a machine with Office 64 installed so I will recommend installing Microsoft Office Access Database Engine 2007 (haven’t tried 2010) found here:
2007: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
2010: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d
"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 Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled"
Resolution :
* Try clearing the IE cache .it may workout to be the best and quick solution
* Try Doing a Repair of Office . or reinstall
* Windows SharePoint Service Support options for Microsoft Office should be installed (applicable for Office 2003 as well as for Office 2007)
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.
* Check if ActiveX controls are active in Internet Explorer.
To do this open IE and go to the Tools menu > Internet options
* Select "Enable" for Script ActiveX controls marked safe for scripting.
* Adjust these settings accordingly and then click OK twice to return to Internet Explorer.
If you are running Internet Explorer 9 (32 and 64-bit are installed at the same time) use the 32-bit version. SharePoint doesn’t like using datasheet view if you are running IE9 on a machine with Office 64 installed so I will recommend installing Microsoft Office Access Database Engine 2007 (haven’t tried 2010) found here:
2007: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
2010: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d
I know this is an old article , but adding the last one - the Office Access Database Engine - solved my issue. Thanks!
ReplyDelete