There’s no point going around in circles with your data. In Excel, any attempt to create a loop with your formula is called circular referencing, and it’s something that Excel stops by default. Any loop where a formula refers to itself (directly or indirectly) will throw up an error—the cycle can’t be completed as the calculation can’t end.Circular references are a problem because they’ll stop your formulas from working and prevent you from reviewing your data. You’ll need to find the circular references in your Excel formulas and fix them, or modify your spreadsheet to be able to get around the problem.Identifying Circular References in ExcelYou’ll often encounter a circular reference when a formula refers back to its own cell, whether directly or through a series of formulas. If you’ve inadvertently created a circular reference, Excel typically flags it with an alert.You can quickly check this for yourself by looking at the status bar at the bottom of the Excel window. If you see Circular References in the bottom-left corner with a cell address, then you have circular references that you’ll need to fix. Go to that address and fix the problem, then check the status bar until it shows no errors on any of your worksheets.Using Excel’s Error Checking ToolExcel also has a built-in tool to help you track down circular references. You can use these steps to find them.Open the Excel workbook you wish to check and select the Formulas tab on the ribbon bar.Click the Error Checking button.From the drop-down menu, select Circular References. This will show a list of addresses for you to fix and direct you to the (first) problematic cell on the list.How to Remove a Circular Reference in ExcelIf you’re not intending to use them, circular references in Excel often lead to incorrect, impossible-to-run calculations. However, removing them is a straightforward process once you’ve identified the problematic cell (or cells) causing it. How you do this will depend on how your spreadsheet is designed to work. A good way to bypass the problem is to copy a cell with a formula and replace it with its final, static result. This might not be ideal, but it can allow you to bypass an error when a formula, relying on another formula’s result, itself relies on that formula’s result to work.Start by locating the cell with the circular reference, which Excel typically flags with an error message. If you select it, you may see blue arrows appear in other cells—this points out the loop that you may need to fix.Next, right-click the cell and select Copy, or press Ctrl + C on your keyboard. Once copied, right-click the cell again and select Paste > Paste Value, or press Ctrl + Alt + V on your keyboard. Repeat these for any other cell references you have in place to get your final formula to calculate properly.How to Allow Circular References in Excel Using Iterative CalculationsIterative calculations is a feature in Excel that allows it to perform calculations a certain number of times. If you’re expecting that you’ll need your formulas to refer back to themselves, you may want to enable iterative calculations so that it allows the calculations to run without showing an error.This feature is disabled by default—it isn’t the ideal behavior for most Excel users. However, if you’re intentionally using circular references for iterative calculations, you’ll need to enable this feature using these steps.Open Excel and press File > Options (or File > More > Options).In the Excel Options menu, click Formulas.Under Calculation options, check the box for Enable iterative calculation and set the values for maximum iterations and maximum changes. This will set a limit on the number of calculations that Excel will perform through a circular reference before it stops, as well as the precision of the final calculations it performs.Press OK to save your changes.Managing Errors in Microsoft ExcelA circular reference in Excel isn’t a critical error, but it will stop your spreadsheet from working. By using the steps above, you can track down the problem and fix it to correct the error in your spreadsheet and allow your formulas to successfully calculate their end result.There are plenty of other errors you might come across in Excel, including the #NUM error. However, as long as you check through your data to correct any formula errors or data integrity, you should be able to fix the problem.The post How to Find Circular References in Microsoft Excel first appeared on Help Desk Geek.