Is there a formula in Excel to automatically detect and flag circular references?

No, Excel doesn't have a built-in formula to automatically detect circular references. However, you can use VBA (Visual Basic for Applications) to create a custom function that checks for circular dependencies. Alternatively, you can regularly use the Trace Precedents/Dependents feature as described above. There are also third-party Excel add-ins that provide more sophisticated error detection capabilities.