Find and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel.

A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you consolidate …

A circular reference occurs when a formula refers to the cell that it's located in. The fix is to either move the formula to another cell, or change the formula syntax to one that avoids circular references.

When you copy a formula that contains a relative cell reference, that reference in the formula will change. As an example, if you copy the formula =B4*C4 from cell D4 to D5, the formula in D5 adjusts …

Excel cannot automatically calculate a formula that refers to the cell—either directly or indirectly—that contains the formula. This is called a circular reference.

找出並移除循環參考。 您也可以深入了解 Excel 的循環參考警告訊息及反覆運算。

Localice y quite una referencia circular. También puede obtener información sobre el mensaje de advertencia de la referencia circular y el cálculo iterativo en Excel.

This argument can be a cell reference, or a fixed value such as "smith" or 21,000. The second argument is the range of cells, C2-:E7, in which to search for the value you want to find.

Entering a reference to the cell in which you are entering the function as the argument won't result in a circular reference warning. FORMULATEXT will successfully return the formula as text in the cell.

Instead, it calculates the values that you would get if you cancel the operation on the Excel client. In effect, the workbook automatically cancels the circular reference.