I am not sure if I post this question in the right
section, but this comes as close to my 'problem' as
possible.

I want to use information from an Excel sheet as
information in a Word document, but (and that's the
problem) I want to use relative links. To clarify: I have
a word document WORD.DOC and an Excel document EXCEL.XLS.
I copy cell A1 from EXCEL.XLS and PASTE AS LINK,
UNFORMATTED TEXT in WORD.DOC and it shows the dynamic
content of cell A1. Now, when I press SHIFT-F9 I see the
path to which the link refers. This is C:\MY
DOCUMENTS\EXCEL.XLS. What I want is that the link refers
to EXCEL.XLS (without pathinformation), so that when I
move both documents to a server or whatever other
location, the links still work without me having to alter
all the 'hardcoded' links.

Looking forward to your responses....