However, here (and in the status bar), only the circular reference entered last is displayed. Then click the displayed references (see Figure 3-14). In the Formula Auditing group, click the Error Checking and then the Circular Referencesīutton. In Excel 2007/Excel 2010, you can find the search and remove options for circular references on the ribbon, on the Formula tab.
#How to use microsoft excel 2003 how to
If you click OK in the circular reference warning in Excel 2010, a help window shows instructions on how to handle circular references (see Figure 3-13).įigure 3-13 Excel 2010 help for circular references. Use the Trace Dependents and Trace Precedents buttons to see what caused the problem. You can use the circular reference toolbar to iterate through the cells within the circular reference. If you click OK in the error message, the circular reference toolbar appears in the table window of Excel 2003 (see Figure 3-12).įigure 3-12 The circular reference toolbar in Excel 2003. Instead you receive the message shown in Figure 3-11.įigure 3-11 Wrong input in cell D3 and error message. Excel cannot resolve formulas with a circular reference. A circular reference is a reference to a cell containing the formula, in other words, a reference to itself.
Microsoft Excel 2010 Formulas & Functions Inside Out (ISBN 9780735658028)Ĭircular references are mostly generated by input errors.
0 kommentar(er)
