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" <(E-Mail Removed)> wrote in message
news:Px0ke.1023$(E-Mail Removed)...
>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..
>
>