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?