Broken links between excel and word...

[hubbabubba]

I have made links between 2 documents (placed in the same folder), one excel and one word document. Everything works as it should. The thing is that when I move the documents from one folder to another the links are broken. Is there a way to keep my two documents linked to each other all the time even though I move them to another folder?

Example:
Files: numbers.xls & text.doc
Placed in folder “C:\folder1”

As it is now the link in text.doc looks like “C:\folder1\numbers.xls”
If I move my documents to “C:\folder2” the link in text.doc will still be “C:\folder1\numbers.xls”.

Summary: I want the link in my text.doc to point directly to the same folder as it is placed in, not “C:\whatever\folder\...”

Anyone who has an idea?