I have two workbooks located in the same folder.
Workbook B contains formulas that refer to cells in a worksheet in workbook A.
I open both workbooks and workbook B is not giving me the results of those formulas. Inspecting more closely, the formulas in B have a #REF in the formulas where the worksheet names should be. The entire path is correct in the formula. The workbook name was correctly indicated. But the worksheet name was somehow and suddenly replaced with #REF even though the worksheet exists! It is located in workbook A.
I close both workbooks and reopen them. The error message goes away and all formulas are working.
Why is this happening and how can I prevent it from happening again?