A formula in a cell that directly or indirectly refers to its own cell is called a circular reference. This is not possible.
In Excel, formulas that have circular references usually do not run and come back with errors. A circular reference error results when a formula refers back to its. Sep 21, 2013 Re: how to stop circular reference warning? As it suggests you have a situation with a chain of cells that somewhere reference themselves. Typically if you have formulae of the order.
1. For example, the formula in cell A3 below directly refers to its own cell. This is not possible.
Note: Excel returns a 0 if you accept this circular reference.
2a. For example, the formula in cell C2 below refers to cell C1.
2b. The formula in cell C3 refers to cell C2.
2c. The formula in cell C4 refers to cell C3.
2d. So far, everything's OK. Now change the value in cell C1 to the formula =C4. Cell C1 refers to cell C4, cell C4 refers to cell C3, cell C3 refers to cell C2, and cell C2 refers to cell C1. In other words, the formula in cell C1 indirectly refers to its own cell. This is not possible.
Note: Excel returns a 0 if you accept this circular reference.
3. To find your circular references, on the Formulas tab, in the Formula Auditing group, click the down arrow next to Error Checking.
4. Click Circular References.
Nixhex11
Board Regular
Hello, I've built a financial performance model that has a opening page questionnaire through which the user answers simple questions and the model automates all calculations thereafter. Annoyingly, two elements of the model create circular reference issues that I've gotten around by having the user type in two numbers that show up on the questionnaire sheet. These two numbers show in cells M66 and M67 and the user has to match these numbers in E66 and E67 respectively. Since the numbers inputted in E66 and E67 affect the data M66 and M67, the data M66 and M67 change a bit each time something is inputted in either E66 or E67 so this process has to be done two to three times to get the numbers to match close enough for confidence. In other words: Step 1: Type in E66 what you see in M66 Step 2: Type in E67 what you see is M67 ----M66 and M67 have now changed so repeat steps 1. and 2 a few times until E66 and E67 are within $5,000 of M66 and M67 respectively Anyway, this process is a bit of a pain and quite inelegant so I'd love to know if there's a macro or a code to automate this. The challenge is once I link E66 to M66 and/or E67 to M67, I have my circular reference issue again. Any help would be appreciated!