Monday, 4 May 2009

Edit in datasheet error in Sharepoint

If you get the below error message, when trying to edit a list in Datasheet view in Sharepoint:
The list cannot be displayed in Datasheet view for one or more of the following reasons:

It could be because you aren't running a Pro version of office (i.e. Office 2003 Small Business Edition or Standard). I believe this is because the Edit in Datasheet feature is based on Microsoft Access, which is only included in the Professional version of office. However the feature can be made available to the other versions of office, by adding the following registry entry:

Be careful when editing the registry.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Common\ProductVersion]

New dword

"ProInfo"=dword:00000001

No comments: