Office 2010 64bit and DataSheet View in SharePoint – Missing anyting?

July 29th, 2010 | Categories: SharePoint

If you’ve been surprised when opening a DataSheet view in SharePoint by receiving a message like the one below:

The list cannot be displayed in Datasheet view for one or more of the following reasons

(Below also message in Slovene for my Slovene-SharePoint-using-friends)

Seznama ni mogoče prikazati v pogledu podatkovnega lista zaradi teh razlogov

Then you’re missing something. The same as me. The support article from Microsoft (located here) explains that we need to do one of the following:

  1. Don’t use 64-bit Office 2010 or
  2. if you have to use the 64-bit version, download and install the 2007 Office System Driver: Data Connectivity Components

This goes for SharePoint 3.0/2007 and 4.0/2010