Fix Circular References in Microsoft Excel When it comes down to the task of fixing circular references in Excel, the only way to accomplish this is to edit the cells that are of cause.

Enable the Auto-Calculate option. Disable Show Formula option. Check the cell format. Check if the formula is entered correctly. Check for Circular References in the spreadsheet. If the ...