Apr 26 2019 08:31 AM
Apr 26 2019 09:13 AM - edited Apr 26 2019 09:15 AM
SolutionHi, there!
I suggest you try the following:
On Book 3 select the cell and give it a name, for example, CellToMonitor (see picture attached.)
Save.
Open Book1 delete the formula on cell A1, and then write it again by pointing to cell B1 in Book 3. You should get something like this on your formula bar:
=Book3.xlsx!CellToMonitor
Save
Open Book2 and do the same as in Book1.
Save
Close all books.
Test ;)
Apr 26 2019 09:21 AM
Apr 26 2019 09:28 AM
Apr 26 2019 09:40 AM
Apr 26 2019 09:47 AM
Is there a way to update the link when closing the source workbook?
Maby this way:
On the open referencing workbook: tab Data, button Edit Links, Update Values.
To be automatic, maybe with a macro in the source workbook that, before closing would tell all the other books to update the links.
Maybe there is something that you can change in your process that would avoid this struggle.
Apr 26 2019 09:13 AM - edited Apr 26 2019 09:15 AM
SolutionHi, there!
I suggest you try the following:
On Book 3 select the cell and give it a name, for example, CellToMonitor (see picture attached.)
Save.
Open Book1 delete the formula on cell A1, and then write it again by pointing to cell B1 in Book 3. You should get something like this on your formula bar:
=Book3.xlsx!CellToMonitor
Save
Open Book2 and do the same as in Book1.
Save
Close all books.
Test ;)