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

A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you consolidate …

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 cannot automatically calculate a formula that refers to the cell—either directly or indirectly—that contains the formula. This is called a circular reference.

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.

Temukan dan hapus referensi melingkar. Anda juga dapat mempelajari tentang pesan peringatan referensi melingkar dan penghitungan berulang di Excel.

找出並移除循環參考。 您也可以深入了解 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.

Instead of entering values, you can refer to data in worksheet cells by including cell references in formulas.

A 3-D reference is a useful and convenient way to reference several worksheets that follow the same pattern and contain the same type of data—such as when you consolidate budget data from different …