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

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 …

When you use explicit cell references like this (where you reference each cell individually, separated by a comma) and delete a referenced row or column, Excel can't resolve it, so it …

Recherchez et supprimez une référence circulaire. Vous pouvez également découvrir le message d’avertissement de référence circulaire et le calcul itératif dans Excel.

Encontre e remova uma referência circular. Saiba mais também sobre a mensagem de aviso de referência circular e sobre o cálculo iterativo no Excel.

查找和删除循环引用。 还可了解 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.

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.

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 …

Click Home > Find & Select > Go To Special. Click Formulas, and if you need to, clear any of the check boxes below Formulas. 4. Click OK. More about finding things in Excel Find or replace …