Re-Linking with New Path
 

Have 1 MASTER excel file that needs to be "moved" from it's current
location.
Have many WORKSHEET excel files that are linked to that master for updating.

How can I update ALL worksheet excel files with the new location of the
MASTER file without having to do it one by one??? Can the links be globally
replaced from a folder perspective; update all??

Your help is appreciated!!

Thank you

Optima

My LinkManager may be your salvation
Email me at Bill_Manville @ compuserve.com (without the spaces) for a
free copy

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

Back in the office;
I have; you did; it worked like a charm!!
Thanks!!

"Bill Manville" wrote in message
...
My LinkManager may be your salvation
Email me at Bill_Manville @ compuserve.com (without the spaces) for a
free copy

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