One option would be to close your master sheet before saving the source
sheets with different names.

Another option would be to do the saving using a macro using SaveCopyAs
rather than SaveAs.

A third option would be to close the source workbooks and just copy the
files to the different locations using Windows explorer (or FileCopy in
a macro).

You haven't said which version of Excel you are using (it always helps
if you do).


For errors appearing when you don't update links see:
http://support.microsoft.com/default...b;en-us;327006

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