J
jtinne
When you are using one book as a reference for another book, does the
reference need to be open to access the data from it?
reference need to be open to access the data from it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
It needs to be open at some time, to get the data, but after that no. When
you open the referencing workbook, it will ask to update links, which you
can accept or refuse. Obviously, if the other workbook has been changed and
you refuse, you still see the old values.
you open the referencing workbook, it will ask to update links, which you
can accept or refuse. Obviously, if the other workbook has been changed and
you refuse, you still see the old values.
J
Juan Pablo González
You mean, when you're linking from a cell to a cell in that other workbook ?
no, it doesn't need to be open.
no, it doesn't need to be open.
J
jtinne
If someone else on the network was to have the file open would it update off
of their PC or would only update when it's open on my PC?
of their PC or would only update when it's open on my PC?
B
Bob Phillips
No, you wouldn't see the changes until the next time you opened it and
updated the links.
updated the links.