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 …

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 …

Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.

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.

Sometimes, you might see a green triangle in the upper-left corner of a cell that contains a formula. Find out what this means and how to prevent this in Excel 2016 for Windows.

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 …

More resources You can always ask an expert in the Excel Tech Community or get support in Communities.

To fix this, change the formula so that its result is between -1*10 307 and 1*10 307. Tip: If error checking is turned on in Excel, you can select next to cell that shows the error. Select Show …