The workbooks I'm using are pretty extensive and I'd prefer not to have to go
back and name ranges. Are there any other options? Could I use read only
versions somehow?

Thanks for the Feedback Dave

"Dave Peterson" wrote:

If you're using formulas with direct links to cells in worksheets in other
workbooks like:
='[book1.xls]Sheet''1'!$C$99

Then if you have the "receiving" workbook open when you make the change to the
"sending" workbook, then you'll see that the formula adjusts.

If it's not possible to have the workbooks open simultaneously, then maybe you
could name your range and use that in the formula, like:

=book1.xls!myNameHere

Then excel will be able to find that cell.

(Use Insert|Name|Define to create that name.)



wrote:

I have a series of about 10 workbooks that have active links with each other.
There is one main workbook that all the others link to, and some of the
others link to each other also. I've been having some problems with keeping
these links consistent when I reformat (insert rows, cut and paste, etc.) the
main workbook. I've heard that as long as you have all the workbooks open
when you change the main one that the changes should transfer over. Is this
true? If not, what else could I do? Also, lets say half the workbooks are
in use during the day, and I want to be able to make changes to these
workbooks during the day, but implement them at the end of the day. Is this
possible?

Thanks and I look forward to your feedback

--

Dave Peterson