Unable to open List in Datasheet view for WSS 3 / MOSS 2010 after installing Office 2010.

This is quite common on Office 2010 64bit versions, but at times may also occur if you install  Office 2010 32bit.

The workaround is quite simple :

1. Install 2007 Office System Driver: Data Connectivity Component


2.Remove the 2010 Component from

Microsoft Office >> Office Tools >> Windows SharePoint Services Support.

Specifically the “Edit in datasheet” feature is supported by the sub-component named “Microsoft Office Access Web Datasheet Component”


3. Close all  MS Office Apps & Browsers.

Now the “View in datasheet” worked for me.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: