Tuesday 19 October 2010

The list cannot be displayed in Datasheet view

Until a couple of weeks ago, I was using Office 2007 on a Windows 7 (x64). Showing SharePoint (MOSS 2007) lists in datasheet view worked fine.
Recently, I changed to Office 2010 (Prof, x64) edition. I fully uninstalled Office 2007 and installed Office 2010.
Then the following error shows up when using the datasheet view:
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 support ActiveX controls.
- Support for ActiveX controls is disabled.

To my surprise, the solution is to install 2007 Office System Driver: Data Connectivity Components, or with other words the Access Database Engine.
So if you love surprises, start working with SharePoint and Office ;)
BTW, I am working with IE8.

No comments: