How to Remove Circular References in Excel. In a Microsoft Excel 2010 spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate.

Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.

If Excel is not highlighting cells in the formula, place the cursor in the cell containing the formula and press fn+f2. This should highlight all the cell references.

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I have an ...

To cross-reference between spreadsheets, you must identify cells using extended addresses. These extended references specify the cell's sheet as well as its column and row.

Anatomy of an Excel formula: Using functions to perform calculations Your email has been sent If you’re fairly new to Microsoft Excel, you’ve probably learned to enter data into cells to ...