Thursday, June 12, 2008

Display Datasheet View in SharePoint 2003

Recently we had a user contact us that was having an issue getting the datasheet view to work in SharePoint 2003. The following message was appearing when attempting to use the datasheet view.

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.
After some investigation there were a few possible fixes.

1) http://www.mindbusiness.de/.../sharepoint-server-2007-moss-2007/
2) http://support.microsoft.com/kb/909506/en
3) http://objectmix.com/sharepoint/329100-cannot-edit-lists-datasheet-view.html

For us the fix was what was behind item #3. Since this customers laptops are delivered with the full Office 2003 suite (Office 2003 Pro, Project, Visio) we uninstalled the trial version of Project 2007 which he had installed recently.

No comments: