Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Integration with Office XP

  Asked By: Samir    Date: Dec 14    Category: Sharepoint    Views: 1129

We have just installed SharePoint 2003 and I understand that the best
integration comes with Office 2003. But I wanted to know if there is any
way to get "Edit with Word" or "Edit with Excel" feature to work on a
document with Office XP. If not, can these links be removed?

Also, the "Export list to Excel" feature is supposed to work with Office
XP but does not. Is this common?



12 Answers Found

Answer #1    Answered By: Hiral Daftary     Answered On: Dec 14

The export is the "Edit in Datasheet" or the ability to
export a list to excel which uses a special Web query file.

This is very helpful. Hopefully these tools can be installed  after the

Answer #2    Answered By: Rosalie Buckner     Answered On: Dec 14

Yes, the SharePoint components In Office Tools (for Office XP) can be installed
afterward through add/remove programs in Contol Panel choosing Microsoft Office
and then going through modify and choosing custom install.

Answer #3    Answered By: Carrie Ross     Answered On: Dec 14

The Export to Excel and Edit in Datasheet feature requires Excel
2003. It won't work with previous versions.

The tools everyone is referring to don't work quite the way you've
been told. Here's the breakdown:

- The tools shipped with Office XP are for SharePoint 2001.
- These tools will only work with the backwards-compatible document
library in 2003. They will not work with anything stored in the
standard SQL-backed document store in 2003.
- There is currently no way to make the "Edit with Office" items work
with Office XP with a SQL-backed store.
- The links can be removed by editing a configration file on the SP
2003 server. The file is "Program Files\Common Files\Microsoft
Shared\web server extensions\60\TEMPLATE\XML\docicon.xml" - this file
defines the mapping of the icons and whether the "Edit with Office"
appears on a extension-by-extension basis.

Answer #4    Answered By: Lisa Hill     Answered On: Dec 14

I am running SharePoint 2003 with the backend on a SQL server. I am not running
the backward compatible components. From my desktop running Office XP, when I
go to a document on SharePoint 2003 and click on edit in Microsoft Word, I am
able to edit the document...so your statement that you can not edit documents in
SPS2003 with SQL backend with Office XP is incorrect.

Answer #5    Answered By: Bret Warner     Answered On: Dec 14

Thank you for the clarification. We will probably look into deploying
Office 2003 slowly but surely.

Answer #6    Answered By: David Small     Answered On: Dec 14

So it looks like we have other factors influencing this. We are just
getting the components installed  and I will let you know our outcome
later today or next week.

Answer #7    Answered By: Troy Tucker     Answered On: Dec 14

There is a document by MS called "Good - Better - Best" that states the
compatibility of the different office  suites with SPS 2003. MS considers
Office 200 as "GOOD" because it does not have the Sharepoint component
to interact with SPS 2003. MS considers Office XP as "BETTER" and Office
2003 as "BEST". You can find this document on the MS site.

Answer #8    Answered By: Monica Bailey     Answered On: Dec 14

This document does not specifically address the links on the drop down
menus. It is fairly specific about some other items but not these links.

Answer #9    Answered By: Chandra Manjrekar     Answered On: Dec 14

Can you be more specific which dropdown menus you are reffering to?
Those little Smart Tag like ones you see with Office 2003 when
hovering over a member of a site/workspace? Or those when you hover
and click on a document stored in a document library?

Answer #10    Answered By: Lora Wall     Answered On: Dec 14

I was speaking of the menus when you hover over a document stored in a
document library.

And the verdict is....it worked for us. Running Windows 2000
Professional, Office 2002 (XP) with the Sharepoint Components added, and
IE 6.0. It does not work on our base install of Office which did not
include the Sharepoint components.

Answer #11    Answered By: Mahendra Parte     Answered On: Dec 14

That's interesting (and thanks for sharing). I was under the
impression that the SharePoint components in Office XP were only
designed to work with SharePoint Portal Server 2001...

Didn't find what you were looking for? Find more on Integration with Office XP Or get search suggestion and latest updates.