Rich wrote:
Will these be automatically updated or is there anyway of
updating the links as a whole to save having to go through
each individual link and recreate link?


If the links are to files in the same directory or a subdirectory
thereof there should be no problems.

Otherwise there will be.

You might find my LinkManager utility (available free by emailing me at
Bill_Manville @ compuserve.com
without the spaces) helpful.

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