Linking files 2 ways

[rob nobel]

I have a work book that is linked to another and vise versa.
As thus:
Workbook A is where the input of data is made;
Workbook B has a link to the input from workbook A;
Workbook A retrieves the altered data back as a link.
Although this all works fine with both books open, I note that if I open
workbook A by itself, that the data it retrieves from Workbook B is not
updated . If However, both books are open, there's no problem. I thought
linked books were updated automatically if the Update remote references has
been selected?? But it appears that the second book is not updated until it
is opened. Is this so, and if so, can this be overcome somehow? I realise
I could have that data also appear on workbook A, but I was hoping to keep
size of file down and avoid doubling up on formulae.
Rob

 

[Paul]

I have a work book that is linked to another and vise versa.
As thus:
Workbook A is where the input of data is made;
Workbook B has a link to the input from workbook A;
Workbook A retrieves the altered data back as a link.
Although this all works fine with both books open, I note that if I open
workbook A by itself, that the data it retrieves from Workbook B is not
updated . If However, both books are open, there's no problem. I thought
linked books were updated automatically if the Update remote references has
been selected?? But it appears that the second book is not updated until it
is opened. Is this so, and if so, can this be overcome somehow? I realise
I could have that data also appear on workbook A, but I was hoping to keep
size of file down and avoid doubling up on formulae.
Rob

The point to realise is that data can be read from a closed workbook but not
written to it. Therefore a workbook will only be updated when it is open.

So, in your situation, you change source data in workbook A and save/close.
Any formulas dependent on workbook B are not up-to-date at this point. Then
you open workbook B and update it, (so it is now updated from the new source
data in workbook A), and save/close. Then you need to open workbook A again
so that it can update from the new information in workbook B. Only then are
both workbooks fully up-to-date.

 

[rob nobel]

Thanks for that Paul. That was what I expected but I hoped there could be a
way round this.
Rob