Find and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in 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.

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.

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 …

Press F4 to switch between the reference types. The table below summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the …

If you want to maintain the original cell reference when you copy it, you "lock" it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula …

Select the cell that contains the error indicator and look at the Formula Bar to verify that cell references are correct. The shortcut menu shows the options available to resolve this warning.

Google Sheets uses the `ImportRange` formula, which is incompatible with Excel, leading to errors when files are migrated. Excel can identify broken `ImportRange` links in migrated files …