SharePoint world of ECM and Information Management

Missed “Edit in Datasheet” in SharePoint 2007

Today they asked about where is my “Edit in Datasheet” item in SharePoint 2007 library ?! Well.. the point why you can’t see this item in library toolbar is that you don’t have Office 2007 installed on client that access SharePoint server. But what if you don’t want to install ALL Office package, because you have really bad environment and want to minimize installation?! Do you really have to install all Office applications or not?! To have this item in libraries menu you only need to install Access from Office 2007, because it responsible for rendering datasheet in SharePoint 2007. Interesting fact, that SharePoint 2003 used Excel for this.

Posted: Tue, Sep 23 2008 13:26 by Michael | with 6 comment(s)
Filed under:

Comments

Chris said:

Hi,

I converted a List view to an XSLT data view in SP Designer and lost "Edit in Datasheet" from the Actions bar.

Do you know how I can resolve this issue?

Thanks

Regards

Chris

sammutchris@gmail.com

# October 3, 2008 2:11 AM

Mohamed Hachem said:

Hello

it will not show up if you have office 2003. you can get the service pack 3 for office 2003 which solves the problem partialy. you will be able to see the dataSheet in edit mode but some special columns will not appear they would only if you have access 2007 though  most of the time lists don't have those special columns "holding media stuff and pictures"

cheers

# April 2, 2009 11:00 AM

Mala said:

Hi,

I converted a List view to an XSLT data view in SP Designer and lost "Edit in Datasheet" from the Actions bar.

Do you know how I can resolve this issue?

# May 20, 2009 12:15 PM

Michael said:

It's behavior by design - you can't edit converted to XSLT data view in datasheet

# May 21, 2009 9:07 PM

Daniel Brown said:

Once again, the installation of Office Applications is NOT required for any functionality on the server with SharePoint.

This was covered in the SharePoint magazine article which was meant to be a draft, but here is an article stating exactly the same.

Installing office on a Server is not supported or recommended nor is it needed in any shape or form on the server!

# July 3, 2009 9:06 PM

Michael said:

Thanks for this note. Updated this post

Is it because my publication was based on several blog posts and I forgot to update my post when found that error (post is dated Sep 2008, and error was found in March 2009 only)

# July 3, 2009 9:08 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)