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

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.

There’s currently no way to use rules that check your formulas for errors in Excel Online. If you have the Excel desktop application, you can use the Open in Excel button to open your workbook to use error …

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.

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.

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.

Change the cell reference in the formula to another cell that doesn't have a zero (0) or blank value. Enter #N/A in the cell that's referenced as the divisor in the formula, which will change the formula result to …

This topic provides help for the most common scenarios for the #VALUE! error in the AVERAGE or SUM functions.

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.