View SharePoint 2010 List in Datasheet View

Wasn’t this the version of SharePoint and Office when everything seamlessly worked on the first try? Not so! It turns out Microsoft wanted to provide just one more reason to upgrade to the next version.

I am trying to view a list in my SharePoint 2010 site and received an extra generic error message. (What is more generic than “Unknown Error”? How about a message that lists three potential issues none of which provide details.”) This is the error message I kept getting in popup wind style.

image

[The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Microsoft SharePoint Foundation is not installed. Your Web browser does not support ActiveX Controls. A component is not properly configured for 32-bit or 64-bit support.]

The issues turns out to be that 64-bit versions of Office 2010 does not contain an important Datasheet component to allow the proper view. This is according to Microsoft’s knowledge base article 2266203 from July 2, 2010 which can be found here http://support.microsoft.com/kb/2266203.

Microsoft provides two solutions for the issue. The first solution is to only use 32-bit Office, unless you must have the benefits of 64-bit. (HUH? I thought the big push was to move toward 64-bit processing and programs.)

The second solution involves installing the 2007 Office System Driver: Data Connectivity Components from Microsoft Downloads at http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en.

As I am running 64-bit Office I tried the second solutions, after the 25 MB download and about 2 minute install time, I was up and editing my lists in Datasheet view.

Advertisements

One thought on “View SharePoint 2010 List in Datasheet View

  1. Thank you for this excellent, time-saving Post!

    I was having a similar problem and the above fix worked for me.
    The actual error that I was getting was as follows, [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.]

    Thanks again,
    –Leroy

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s