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

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.

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.

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.

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 text and …

查找和删除循环引用。 还可了解 Excel 中的循环引用警告消息和迭代计算。

找出並移除循環參考。 您也可以深入了解 Excel 的循環參考警告訊息及反覆運算。

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 …

ค้นหาและนําการอ้างอิงแบบวงกลมออก คุณยังสามารถเรียนรู้เกี่ยวกับข้อความเตือนการอ้างอิงแบบวงกลมและการคํานวณซ้ําใน Excel