Forum Discussion
Strange Circular Reference Errors
I've been getting reports of some strange Circular Reference errors in a workbook. Unfortunately I'm not allowed to share the workbook or any images of it, as it contains sensitive company data. Th...
To identify and fix Circular Reference in your Workbook: click on Formulas > Click on the little dropdown beside Error Checking > Click on Circular Reference and locate the cell or cells that has the problem.. Then, you fix the issue appropriately
In my case, Excel lets me load my workbook, but with the message "Excel cannot calculate a formula. There is a circular reference in an open workbook, but the references that cause it cannot be listed for you." Some worksheets have a general "circular reference" message, others point to apparently random cells. I've tried Error Checking in the Formula Auditing group, but in my case the Circular References is greyed out. I suspect it may be linked to my recent use of dynamic arrays.
