I have an excel spreadsheet that contains calculations and a Word document
that has a number of link references to it within the text of a report.
Everything works fine and the excel sheets show up in the report as another
page with headers and footers and correct page numbers etc.

The problem occurs when I want to copy the two files to another project
subdirectory and then try to make chnges to both. All the links in the Word
document still refer back to the original excel spreadsheet back in the
first project subdirectory. I have to manually repoint all the links to the
new project subdirectory. Is there any way to cause the link to be to a
relative address, that is make it look for the excel file in the same
directory that contains the Word file? I can only figure out how to tell it
absolute addresses of links

I will also post this in the Excel group..

Hi Jim

If you do Alt-F9, you will expose all the field codes in the document. You
can then search and replace the text within the field codes. So the simplest
solution might be to search for the old path name and replace with the new
path name. Alt-F9 toggles between field results and field codes and F9
updates a field.

You can also edit the field codes to use relative paths. But Word sometimes
prefers absolute paths, so test thoroughly.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Jim" wrote in message
nk.net...
I have an excel spreadsheet that contains calculations and a Word document
that has a number of link references to it within the text of a report.
Everything works fine and the excel sheets show up in the report as
another
page with headers and footers and correct page numbers etc.

The problem occurs when I want to copy the two files to another project
subdirectory and then try to make chnges to both. All the links in the
Word
document still refer back to the original excel spreadsheet back in the
first project subdirectory. I have to manually repoint all the links to
the
new project subdirectory. Is there any way to cause the link to be to a
relative address, that is make it look for the excel file in the same
directory that contains the Word file? I can only figure out how to tell
it
absolute addresses of links

I will also post this in the Excel group..