SharePoint Error “The list cannot be displayed in Datasheet View”

Tag: sharepoint Author: kxw333 Date: 2009-12-29

How to fix this error in SharePoint:

"The list cannot be displayed in Datasheet view. A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls

It started to days ago, for apparently no reason. ActiveX is enabled on this site and I had everything working fine so far. Not sure what went wrong.

Thanks,

Best Answer

... from IE check out your Internet Options, and look under 'Programs'->'Manage Add-Ons'

When I had this problem it was because an add-on was missing or disabled... * thinks * "Microsoft Office List 12.0" or something.

comments:

I have Microsoft Office List 11.0 enabled - still not working and no idea how to fix it. The most recent thing I downloaded was Java, you think might have something to do with that?
Hmmm... no idea then :( Just to be thorough; what version of Office? What SP?
ms office 2003; SP 3; and sharepoint designer 2007; ie v7
Hmmm... then I'm not too sure. Best I can offer is parroting this: codeforfuture.com/2009/04/22/…
thanks for the link - it helped!

Other Answer1

This is known issue and you have to install the hotfix provided by Microsoft.

The issue is addressed in the below specified link along with the URL for the hotfix.

http://www.himmeltech.com/blog/fix-for-datasheet-view-issue-error-in-sharepoint-2010/

Let me know whether the suggested solution fixes your issue

comments:

It is recommended not only to provide a link as answer, but summarizing the important contents. that way the answer stays complete even if the linked content vanishes ;)

Other Answer2

Seems like a client/browser problem.. do you have Microsoft Office installed? Did you change security settings in Internet Explorer?

comments:

Checked all: settings; upgraded my browser; ms office. Everything is fine, except for my Datasheet view. I am the admin on that site, and is only not working for me, the other users are fine.

Other Answer3

Please install below data connectivity component to resolve this issue.

http://www.microsoft.com/en-us/download/details.aspx?id=23734