| Error checking is linked to 'smart tags'
from Excel XP up. 'Smart tags' are the small
green (by default) triangles in the top left of
a cell. They can be used to indicate information
about data in the cell or indicate a possible
problem/error in it. This option is used to
diagnose the latter. In the example below we
have two errors, a #DIV/0! error (in C1) and a
number in a cell formatted as text, (in B2).
This example shows the first error:
Pressing the 'Next' button cycles to the
second error:
The buttons, as you can see change depending
on the 'error', either fixing it or referring
you to help on the error. 'Show Calculation
Steps...', launches the 'Evaluate' dialog, as
under 'Tools>Formula
Auditing'. The other options allow you to
ignore the error or edit it in the formula bar,
(while you do this the controls on the dialog
are disabled, except the top one, which will be
labelled 'Resume', allowing you to move
backwards or forwards again to other errors.
The 'Options...' button, displays the dialog
below, to set global rules for what is seen as
an error. If you have chosen to 'ignore'
any errors, either through this dialog or an
individual smart tag, you can reset these here
too. (This dialog is available separately
through 'Tools>Options...').
 |
