Link TO/FROM closed workbooks !

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marco - 04 Dec 2003 16:50 GMT

Please Help me ! I have a problem ...

I linked the cell "A10" of 30 workbooks to the cell "A10" (Value =
25%) of the workbook we'll call "Master", so I can change the value
for 30 workbooks in one time.
I have to work only with the WB "Master" open and the other WBooks
closed.
In all closed Workbooks we have:
A10 25%
A11 200 (This Value changes in every workbooks)
A12 50 (Result of = A10 x A11)

The cells "A12" of every closed workbooks are linked in "Master" by 30
links.

The problem is:

When I change the cell "A10" of "Master" with new value 27,5% , the 30
links to closed workbook don't change.
It works only if I open all the 30 workbooks .
... and I don't like open all 30 files every time I change "A10" value
of "Master" workbook.

Thanks a lot for your help
Marco

Reply to this Message

J.E. McGimpsey - 04 Dec 2003 19:03 GMT

Not much you can do - to calculate, a workbook needs to be open.

You could write a macro to open, save and close all 30 workbooks.

OTOH, it looks to me like your links in the Master workbook could
instead rewritten to multiply Master's A10 by the external
workbook's A11, right? Then you wouldn't need the other books to
calculate.

For instance instead of

Master, sheet1:
A10: 27,5
J13: = <path>[wkbk2]sheet1!A12

use

J13: =A10 * <path>[wkbk2]sheet1!A11

and avoid the round trip.

> Please Help me ! I have a problem ...
>
[quoted text clipped - 21 lines]
> Thanks a lot for your help
> Marco

Reply to this Message