Thursday, August 27, 2009

Sharepoint Datasheet View + Office 2003 Pro + Office 2007

I've been scratching my head over this one for a little while and was motivated today to fix it. So here it is.

My office has MS Office 2003 Professional and MS Office 2007 installed.

And we obviously use Sharepoint.

Users who try to get into the Datasheet view would get the following 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."

Users who try to open the list in Excel get the following:
"The Column_name column is a read-only column that cannot be modified."

If you get those above symptoms. Try checking this KB:
http://support.microsoft.com/kb/952608

It worked for me.

Good luck