MS Excel 2007 - Links with MS Word - Links Lost by Email

[Caz59]

Hi there,

Am using MS Office 2007, I have created an Excel document and some Word documents, all links working just fine.

If I email the documents to anyone all the links are lost. On my own computer when I open Word it asks if I want to update the links, fine me thinks.

If I then email the files to anyone all the fields in Word are lost and when right clicking on the Word fields I get a drop down menu with Object and not Update Link.

HELP!

 

[macropod]

Hi Caz59,

In Word, links to external files are via absolute paths, and these don't update to reflect a change in the relative addresses of the files - even if they're in the same folder. To see how you can work around this, visit:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=670027

and

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=261488

Cheers

[MS MVP - Word]

 

[Caz59]

Thanks, will give it a go, had realised that it was a path problem as when pressing Alt-F9 in the Word document saw the original path.

Painful as will have to change a lot of links, aaahhhh.....

 

[Caz59]

Hi Macropod or anyone else,

Well have had a go at this and still can't get to work. There just must be a way to make the paths relative and not absolute.

Please help!

All the best,
Caz

 

[macropod]

Hi Caz59,

As previously indicated, the filepaths inserted by Word are always absolute. The links I posted take you to workarounds for making fields other than LINK fields (which is what you've got) relative, and macros that will update link fields also. If all your files live in the same folder, the macro at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=670027

will solve the problem.

Cheers

[MS MVP - Word]