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.
[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.