Word/Excel links via Paste Special

[derekbagnall]

I have linked together a Excel spreadsheet (source) and Word document
using Paste Special for various fields. The 2 files are in the same
directory.
If I copy both files to another directory then it seems some links are
relative and work from the new copy (correct for what I want), but some
are absolute and still refer to the original.
How can I control the type of link, they look identical in the original
Word doc.

Thanks,
Derek

 

[Cindy M -WordMVP-]

Hi Derekbagnall,

A LINK field will not support a relative link. An IncludeText field
would, but I'm not sure which Paste Special option would give you that...
Insert/File with a link would, though.

Press Alt+F9 to see the fields and you should be able to see which ones
have full paths, which relative, and what field type these latter are.

Note that Word will look for "missing" link files under some
circumstances, and even find them if they're in a directory in the
Window's PATH setting. You may be seeing this, rather than relative
paths.

I have linked together a Excel spreadsheet (source) and Word document
using Paste Special for various fields. The 2 files are in the same
directory.
If I copy both files to another directory then it seems some links are
relative and work from the new copy (correct for what I want), but some
are absolute and still refer to the original.
How can I control the type of link, they look identical in the original
Word doc.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 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