Obviously sometimes the datasheet view is not working for clients using Microsoft Sharepoint Server. The reasons are multiple, depending on the Office product and release. Symptoms differ from does just not work to the following error message:
“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 browser does not support ActiveX controls, or support for ActiveX controls is disabled. ”
Microsoft states http://support.microsoft.com/kb/909506/en-us that this behavior is by design.
It is only available in Office Professional, not standard, not SBE.
If found some workarounds on the net:
http://wss.collutions.com/Lists/FAQ/DispForm.aspx?ID=253
The following page gives an overview on the functions per MS Office package.
http://support.microsoft.com/kb/840024/en-us
It seems furthermore that the function to show a datasheet in Excel per default is not working anymore with Office 2007 installed. It seems to be the design of Microsoft to open any form in Access view only, once Office 2007 installed. It would be great if anyone can confirm or tell me about a known workaround for this.
Find more information on using Word, Excel, and Excel Services with SharePoint 2007 here: http://assets.devx.com/download/19873.pdf
Sphere: Related Content
Recent Comments