Use tracing a Circular Reference. For those who are working with complex formulas, in many cases, it won’t be easy to identify the source of a circular reference in Microsoft Excel due to the ...

How to Remove Circular References in Excel. In a Microsoft Excel 2010 spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate.