I have an extensive excel sheet that has pages getting data from other pages within the document. It is about a 7 page document. All the pages pull data from the first page document. Sometimes when people insert data on page one, the other pages get a ref error in certain cells.
EX:
Sheet 1 cell A1- Hi
Sheet 2 cell A1- =Sheet1!A1 (Thats what the formula is)
Then when i look at cell A1 on sheet 2 it says #REF!
Is there a way I can prevent this happening or someone tell me why this happens?
Bookmarks