Updating linked data across 3 workbooks

mattvanice

New Member
Joined
Oct 26, 2006
Messages
2
I have three workbooks (book1, book2, and book3). The data on book1 is updated manually. bookt2 links data from book1 and does various calculations. I want book3 to pull its data from book2. I have set it up exactly how I want it; however, the links only work on book3 when I have book2 open. It seems that when book3 is open by itself and I am update the links, it goes to book2 and sees that those values are not updated and i receive an error in book3. Is there a way to update the links on book2 opening only book3?
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,113,849
Messages
5,544,645
Members
410,627
Latest member
georgealice
Top