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.

If you want to find and fix Circular References in Microsoft Excel, then this guide will help you get the job done with ease.

If ExcelCalculationOption.AllowCircularReferences is set to true a cell containing a circular reference will be handled as a cell containing no value, which is more like how Excel handles it after the ...