Excel 2010 - #REF messages that should NOT happen!
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm playing with the two files now and everything is fine. I can't seem to reproduce the error.
Yes, I have the fully qualfied path in my references. That's what mystified me.
What also mystified me was the fact that the error was so selective. It only gave me a #REF for the worksheet name, not the path, not the cell.