Share via

Resolution to missing datasheet view with 64-bit versions of Office

  • Article

I just saw the following from our Product Quality team, and thought I would pass along the resolution.  While 64-bit installations of Office 2010 are still relatively uncommon, there are a few known issues/growing pains, and this is one of them Smile

Issue:

Datasheet feature on SharePoint not available for customers who install the 64-bit version of Office 2010.  When clicking on the Datasheet View, the following message is displayed:

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.

Description:

Customers using the 64-bit version of Office 2010 are unable to use the Datasheet view of SharePoint lists. This issue occurs regardless of what version of SharePoint the customer is using: Windows SharePoint Services 2.0, Windows SharePoint Services 3.0, SharePoint Foundation 2010, SharePoint Server 2003, SharePoint Server 2007 or SharePoint Server 2010. The picture below is an example of the experience with SharePoint Server 2010 when you click the Datasheet View button.

clip_image002

The component that provides this functionality is not installed during the setup of the 64-bit version of Office 2010 because a 64-bit version of the Datasheet component does not exist.

Resolution:

Customers using the 64-bit version of Office 2010 can install the 2007 Office System Drivers: Data Connectivity Components to regain the Datasheet functionality when using the 32-bit version of an internet browser.

The resolution is documented in KB 2266203: You cannot view a list in Datasheet view after you install the 64-bit version of Office 2010.

Comments

  • Anonymous
    January 23, 2012
    So we would need to change the OS back to XP64 bit  - RAM limitations to get IE 7.  Window 7 64bit is IE 8. Or will that not work at all?  We have to stay with 32 bit 4Gb ram?

  • Anonymous
    February 15, 2013
    The comment has been removed

  • Anonymous
    November 04, 2013
    You can still run 32bit office on 64bit Windows.  No need to run 64bit Office unless you have massive spreadsheets with powerpivot cubes.

  • Anonymous
    June 09, 2015
    I am running Office Pro Plus 2013 32-bit, on windows 8.1 Pro 64-bit, IE 11 doesn't state 64-bit thus according to what I've read should be 32-bit. I cannot manage libraries and lists in Datasheet view in SharePoint 2010 Foundation. However, I can manage Quick Edit (data sheet view) in SharePoint Online (2013) . Any thoughts?