SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I try to put my "upgraded 2007 to 2010" list in "Datasheet View" I get an error:

This 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 first one, I would think, is out because I installed SharePoint 2010 Enterprise. The second one is out because it worked for my old site and I have the site under my "Local Internet" security allowing all. The third one seems unlikely because the old site was 64-bit also.

Any ideas?

share|improve this question

Just a lucky guess, but are you using Office 2010 x64, because:

The Edit in Datasheet view functionality is not supported if you install 64-bit Office 2010. However, the functionality is available if you install 32-bit Office 2010.

Source: 64-bit editions of Office 2010

share|improve this answer

I am using Office 2010 64-bit with SharePoint 2010 64-bit (I didn't know they made a 32-bit)

I found the answer: If you are already runnig Office 2010 64-bit just install 2007 Office System Driver: Data Connectivity Components from Microsoft's site.

It works fine now.

share|improve this answer
The "official line" is to only run Office 64-bit if you need big Excel spreadsheets. Otherwise it's not necessary and you can run into compatibility problems like this. – Alex Angas May 27 '10 at 22:42
There are a number of issues with the 64-bit version of office, I would stay away. – Mike Oryszak May 27 '10 at 23:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.