Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

2 Answers

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
add comment

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. http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

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
add comment

Your Answer

 
discard

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