1. Introduction If you’ve ever opened an Excel workbook only to see numbers behaving strangely or worse, not changing at all you might be dealing with a circular reference. In Excel, a circular reference occurs when a formula refers back to its own cell, either directly or indirectly. These sneaky…