I don't believe there is a way to change how links are treated when a
workbook is moved.

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