Microsoft Office Tutorials and References
In Depth Information
Excel’s Auditing Tools
If you can’t figure out the source of the problem, use Formulas
Circular References. This command displays a list of all cells that are involved in the
circular references. Start by selecting the first cell listed and then work your way down the list
until you figure out the problem.
Using background error checking
Some people may find it helpful to take advantage of Excel’s automatic error-checking feature.
This feature is enabled or disabled by using the check box labeled Enable Background Error
Checking, in the Formulas tab in the Excel Options dialog box shown in Figure 21-11. In addition,
you can specify which types of errors to check for by using the check boxes in the Error Checking
Figure 21-11: Excel can check your formulas for potential errors.
When error checking is turned on, Excel continually evaluates your worksheet, including its
formulas. If a potential error is identified, Excel places a small triangle in the upper-left corner of the
cell. When the cell is activated, a Smart Tag appears. Clicking this Smart Tag provides you with
options. Figure 21-12 shows the options that appear when you click the Smart Tag in a cell that
contains a #DIV/0! error. The options vary, depending on the type of error.
In many cases, you will choose to ignore an error by selecting the Ignore Error option. Selecting
this option eliminates the cell from subsequent error checks. However, all previously ignored
errors can be reset so that they appear again. (Use the Reset Ignored Errors button in the
Formulas tab of the Excel Options dialog box.)