If the source and destination files are in the same folder the files
can be moved to a different folder and the link will still work.

If the source file is in a subfolder of the folder containing the
destination file the whole structure can be moved and the link will
still work.

Otherwise you need to change the links.

See if you can arrange your files differently.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup