SharePoint Experts, Information Architects, Expert Witness

We provide consulting in a broad array of business and technology from architecture to design to deployment of global systems with a focus on surfacing data in the enterprise. Specialists in Microsoft, we are a premier provider of SharePoint Expertise (including 2016 and Office 365). We also provide Expert Witness/Legal Expert in eDiscovery, source discovery, patent infringement, piracy and more! We also have established SICG DLDS s.a. - our counterpart in Costa Rica that specializes in water systems (http://www.crwatersolutions.com) - Contact me direct: david_sterling@sterling-consulting.com or call 704-873-8846 x704.

Search This Blog

Thursday, June 30, 2011

SharePoint 2010 The List Cannot be displayed in Datasheet view for one or more of the following reasons

So you setup a brand new SharePoint 2010 site and found that like MOSS, it can be a pain to get the Datasheet View working - to wit:

"The List Cannot be displayed in Datasheet view for one or more of the following reasons"

You may also have problems with the GridView - this solution fixes both problems. The problem is that the Office components needed are not installed, SharePoint 2010 needs BOTH the 2010 and 2007 components to work properly.

The guaranteed fix is to do the following (do this in order - x64 MUST be installed before x86, i.e. 2010 before 2007.

1) Install Office x64 (does not have to be licensed)

2) Download and install:
Microsoft Access Database Engine 2010 Redistributable
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255

3) Download and install:
2007 Office System Driver: Data Connectivity Components
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

After these, run and IIS reset and off you go!

SIDE NOTE: If you want to run a copy of SharePoint Designer on the server (i.e. a staging or test environment), you must install SharePoint Designer x64 BEFORE the 2007 Office System Driver.

No comments: