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 references.

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

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.

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.

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.

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 returns the #REF! error.

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 …

Change a cell reference from relative (default) to absolute to maintain the original cell reference when you copy it. Maintain cell reference by putting a dollar sign ($) before the cell and column references.