Solved: Question About Circular References

[Opv]

I recently found a VBA script from Microsoft for identifying all circular references in a worksheet. Now I'm curious. Is it possible to have circular references without receiving a Circular Reference alert within Excel?

I ran the Microsoft script on a large spreadsheet that otherwise shows no errors and all the formulas appear to be working correctly; however, the report generated from the Microsoft script shows that there are numerous circular references. How is that possible?

Opv

[Jan Karel Pieterse]

If you set the iteration to true, then Excel will issue no warnings on circular references. Try unchecking iteration.

[Opv]

If you set the iteration to true, then Excel will issue no warnings on circular references. Try unchecking iteration.
Thanks. I turned off Iteration and performed a recalculation. I'm not receiving a circular reference error. Not sure why the Microsoft script report is reporting so many problems.

Oh well, thanks.

Opv