Updating References and Re-Establishing Links

If you open a dependent worksheet before opening its source document or documents, you ll get an Update references to unopened documents message. If you press the Yes button, the data must be updated and there can be a delay, depending on the size and complexity of the documents. If you press No, you ll get either whole columns of VALUE error values, or even worse, values that are not updated. So it s advisable to open all source documents before beginning to open dependent documents. For the same reason, always save the source worksheet before saving the dependent sheet linked to it. 

If you edit a source worksheet, the cell references in the dependent worksheet will be updated, provided the dependent worksheet is open. The same is true if you change the name of a source document or move it to a different directory. If you rename or move a source document while the dependent document is closed, references will not be updated and you ll get a Can t find document message, and will have to re-establish the links between the documents. 

---