Data Sheet View Not Working?

By Arttu ArstilaMarch 31 2010 2 comments

The data sheet view in SharePoint is a useful tool for quickly editing several list items. It exists also in SharePoint 2010.

When using the browser of the SharePoint server, the data sheet view does not usually load, even though it works fine on the client workstations.

This is by design, as the data sheet view is implemented by using an ActiveX component called Access Web Datasheet. This is installed in Office Suite by default, but installing office clients on servers usually seems unnecessary and potentially hazardous. Luckily Microsoft provides free Access Runtime installer which is enough to enable Access Web Datasheet functionality. There are downloadable versions for Access Runtime 2007 and 2010 Beta. It seems that Access Runtime 2007 works well with SharePoint 2010:

DataSheet View

Popularity: 21% [?]

, ,

2 comments to “Data Sheet View Not Working?”

  1. Laying the Foundation for SharePoint Deployment; Azure Will Have VM Support; Google Changes Name to Topeka - SharePoint Daily - Bamboo Nation says:
    April 1, 2010 at 15:06

    [...] Data Sheet View Not Working? (SharePoint Blues)No comments yet .The data sheet view in SharePoint is a useful tool for quickly editing several list items. It exists also in SharePoint 2010. When using the browser of the SharePoint server, the data sheet view does not usually load, even though it works fine on the client workstations. [...]

  2. SharePoint 2010 Datasheet view not available // Train-A-Scope – Steven Knight Training – Linking People and Technology – Steven Knight Training says:
    January 5, 2011 at 09:23

    [...] http://www.sharepointblues.com/2010/03/31/data-sheet-view-not-working/ [...]

Leave a Reply

«
»