You will get an error as below while listing the items in datasheet view.
Error Description:
The list 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 Web browser does not suppoft ActiveX controls.
- Support for ActiveX controls is disabled.
[OK]
Solution:
You need to edit the registry key for this solution. take the backup of the registry.
In the registry, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Common\ProductVersion.
Right click on 'ProductVersion' folder and select 'New -> Binary value'.
Change the Value Name to 'ProInfo'.
Set its value to '0000 00 01'. The first 4 zeros will be populated by default. You need to keey in 0001 only. The alignment between the digits is taken care automatically.
Save and close the registry.
Note: One of the causes of this error is that SharePoint has identified the installed version of Microsoft Office Excel as 'Standard' rather than 'Professional'
***Share your comments about this post***
Error Description:
The list 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 Web browser does not suppoft ActiveX controls.
- Support for ActiveX controls is disabled.
[OK]
Solution:
You need to edit the registry key for this solution. take the backup of the registry.
In the registry, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Common\ProductVersion.
Right click on 'ProductVersion' folder and select 'New -> Binary value'.
Change the Value Name to 'ProInfo'.
Set its value to '0000 00 01'. The first 4 zeros will be populated by default. You need to keey in 0001 only. The alignment between the digits is taken care automatically.
Save and close the registry.
Note: One of the causes of this error is that SharePoint has identified the installed version of Microsoft Office Excel as 'Standard' rather than 'Professional'
***Share your comments about this post***
No comments:
Post a Comment