Datasheet

132
PART II
■
GETTING THE DATA IN
Figure 4.27. Tracing a formula
Locating worksheet errors
Errors and invalid data seem to sneak into even the most scrupulously
designed and maintained worksheets. You can find them with the help of
a few tools on the Formula Auditing toolbar. If you see an error, refer to
Table 4.2, which provides a list of what the errors mean and how to fix
them.
To show the Formula Auditing toolbar, right-click in the toolbar area
and click Formula Auditing.
Precedents back two levels
Trace Precendents
Precedents back one level Dependents forward one level
Trace Dependents
Remove All Arrows
Remove Precendents Remove Dependents
09_763217 ch04.qxp 1/18/06 11:23 PM Page 132