If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link TO/FROM closed workbooks !
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 |
Thread Tools | |
Display Modes | |
|
|