SharePoint list data sheet view or excel like view is not working


Installed the 2007 Office System Driver: Data Connectivity Components as per the URL below and it started working.

In our case we cannot view a list in Datasheet view after we installed the 64-bit version of Office 2010


By design the data sheet view is implemented as an ActiveX component called Access Web Datasheet.

If you are on the server and try to test this functionality this may not work due to unavailability of office clients on server.

Installing office clients on servers usually seems unnecessary and potentially hazardous.

Just install Microsoft provided free Access Run-time installer, as per the link provided above,  which is enough to enable Access Web Datasheet functionality.


Leave a Reply

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

You are commenting using your 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 )

Google+ photo

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

Connecting to %s