One more time: how to paste a link from excel sheet

[smiechu]

Hi

Maybe nobody understand my previous post, then i try one another time (I
promise - last time )

I have got two documents placed into same folder (e.g. /project). In excel
sheet I have calculation tables, word document I use to present data.

When I wont to use them, I copy files from this folder to another (e.g.
/project/project1) and calculate data in excel sheet.

But links in word document shows data from excel file placed into /project
folder (not from current).

I use win XP home and ms office 2000 9.0.3821 SR-1

When I use same office on win 2000 pro word takes data from excel files
placed in current folder.

I tried to replace links using find-replace tools but it doesn't work

Manually I don't wont because in this document it is a lot of links.

Any ideas?

best regards

Tomasz

 

[Rob Schneider]

I believe you need to use the Edit/Links... menu to change the links
from the old file names to the new file names.

 

[Cindy Meister -WordMVP-]

Hi Smiechu,

Word uses fields to support links. When you copy/paste with Excel
information, this generally generates a LINK field. Link fields require
absolute paths; they do NOT support relative path names.

If you haven't formatted the Excel objects with any text wrapping, you can
press Alt+F9 and use Find/Replace to change the paths.

I have got two documents placed into same folder (e.g. /project). In excel
sheet I have calculation tables, word document I use to present data.

When I wont to use them, I copy files from this folder to another (e.g.
/project/project1) and calculate data in excel sheet.

But links in word document shows data from excel file placed into /project
folder (not from current).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail