Remove or allow a circular reference in Excel - Microsoft Support
Find and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel.
How to avoid broken formulas in Excel - Microsoft Support
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 …
Supprimer ou autoriser une référence circulaire dans 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.
在 Excel 中删除或允许循环引用 - Microsoft 支持
查找和删除循环引用。 还可了解 Excel 中的循环引用警告消息和迭代计算。
Remover ou permitir uma referência circular no 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.
How to correct a #REF! error - Microsoft Support
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 …
Change formula recalculation, iteration, or precision in 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.
Quitar o permitir una referencia circular en 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 中移除或允許循環參照 - Microsoft 支援服務
找出並移除循環參考。 您也可以深入了解 Excel 的循環參考警告訊息及反覆運算。
Switch between relative, absolute, and mixed 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 …