And now you're probably saying, "Hang on, a last calculated value?" Yes. When you close the message, Excel displays either a zero or the last calculated value in the cell. The first time Excel finds a circular reference, it displays a warning message.
Learn about the circular reference warning message You show the tracer arrow by clicking Formulas, and then click either Trace Precedents or Trace Dependents. The arrow indicates the cell that affects the value of the currently selected cell. You can move between cells in a circular reference by double-clicking the tracer arrow. If you have circular references in other worksheets, but not in the active worksheet, the status bar displays only “Circular References” with no cell addresses. The status bar in the lower-left corner displays Circular References and the cell address of one circular reference. If you're brand new to working with formulas, see Excel 2016 Essential Training at LinkedIn Learning. If you can't determine whether the cell is the cause of the circular reference, click the next cell in the Circular References submenu.Ĭontinue to review and correct the circular references in the workbook by repeating steps any or all of the steps 1 through 3 until the status bar no longer displays "Circular References." If you can't find the error, click the Formulas tab, click the arrow next to Error Checking, point to Circular References, and then click the first cell listed in the submenu. If this confuses you, imagine what it does to Excel. They happen when you put a formula in cell A1, and it uses another formula in B1 that in turn refers back to cell A1. While you're looking, check for indirect references. Formulas like =A1+1 (in cell A1) also cause circular reference errors. For example, cell A3 might contain the formula =(A1+A2)/A3. If you just entered a formula, start with that cell and check to see if you refer to the cell itself. You can also try one of these techniques:
0 kommentar(er)
