OK thanks to both of you. I was so shocked that Excel changed the workbook
names I just wanted to lock them in place as absolutes, which I would do if I
knew how. All your suggestions make sense, and I am sure I can work through
that. Closing the master and saving over the component spreadsheets instead
of deleting them I think will be the best solution.
Interestingly, I just found that once I recreated all the ocmponent files
the workbook references all changed back to what they were supposed to be.
This is good, but I would love to take control away from Excel in this case.
I have a second problem when changing the formulas in the master that
reference the separate workbooks. With 13 columns and 100 rows that is 1300
formulas, with 100 to each column. I have to change the references if I make
a change to the component format, and alter the location of the cells I am
referencing on the separate workbooks.
What I find is that when I change a formula with a separate workbook
reference I am prompted for file location. I am not changing the location,
and I can cancel that dialog by hitting the cancel button or just hitting
escape, however when I am changing 100s of formulas I want to use Replace
All, and that means hitting Esc for every cell being changed during what
should be a one touch procedure. Further, there are times when it doesn't do
this, and it seems arbitrary to me. It did this when the component
spreadsheets were deleted, but recreating them all didn't ichange the result.
I just went back again to try it and now I am not getting the prompt.
Again, I seek control over this process, which serves no purpose in the first
place since I am not posting a new location. The arbitrariness of the
problem suggests there is a bug here, but I am still wondering whether there
is a way to prevent the prompt.
Thanks again for your help.