Good news! You don't have to do anything.

If the formula links are all to files in the same directory then Excel
will automatically correct them if the source and destination files are
all moved to a different directory.

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