I have a financial forecast model that occasionally indicates a circular reference even though there is none there.
From time to time, when I open the file, it indicates that there is a circular reference. If I follow the cell and try to find the error, I can never find it. But if I close excel and re-open the file, the circular error reference will not re-appear.
I may use, save and re-open the file repeatedly over a few days with no circular reference, and then one day I'll open it and it says that it's there.
This is a large workbook with some complex formulas. It has about 8 tabs and a lot of references between the tabs. It has only one small section that references another workbook.
Anybody seen this before? I hate circular references.
Thanks,
JPF
From time to time, when I open the file, it indicates that there is a circular reference. If I follow the cell and try to find the error, I can never find it. But if I close excel and re-open the file, the circular error reference will not re-appear.
I may use, save and re-open the file repeatedly over a few days with no circular reference, and then one day I'll open it and it says that it's there.
This is a large workbook with some complex formulas. It has about 8 tabs and a lot of references between the tabs. It has only one small section that references another workbook.
Anybody seen this before? I hate circular references.
Thanks,
JPF