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...
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.