I did not notice the link at the bottom of your answer until just now, but I
have reviewed the site, which states that these problems could exist when
working with sheets that are not all from the same version of excel. In my
case, this is not so, all my linked sheets are saved as Excel 2002 and are
all found on the same office server and only updated and changed by me.

Any other ideas?

"Arla M" wrote:

Sorry I am using Excel 2002.
Well I suppose the simplest answer to the first question is to make sure my
master sheet has been closed before renaming the other sheets.
As for my last 2 questions about the #VALUE! and #REF! ... Is there
something besides ensuring all my sheets are open at once to prevent this?
It becomes cumbersome having to open 20 worksheets at the same time when I am
not neccessarily needing to work in them. And once a formula has #REF! I've
never been able to get it to work again unless I repaste my link... which is
a real pain in the butt.

"Bill Manville" wrote:

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