• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Auditing

To avoid bogus results from incorrect formulas, you can have Excel show you which cells have supplied data for a formula. If a formula uses a particular cell, the formula is said to be dependent on the cell, and the connection between them is a dependency.

To display formula dependencies:

1.
Select the cell or cells that contain the formulas (Figure 11.43).

Figure 11.43. Select cells that contain formulas.


2.
Choose Tools > Auditing > Trace Precedents (Figure 11.44).

Figure 11.44. Choose Tools > Auditing > Trace Precedents.


Arrows appear in the sheet, showing formula dependencies (Figure 11.45).

Figure 11.45. Arrows show formula dependencies.


3.
Choose Tools > Auditing > Trace Precedents again to see an additional level of precedents, if it exists.

4.
To see which formulas depend upon a particular cell, click that cell and choose Tools > Auditing > Trace Dependents (Figure 11.46).

Figure 11.46. Choose Tools > Auditing > Trace Dependents.


Arrows point from the cell to the formulas that depend upon it (Figure 11.47).

Figure 11.47. Dejpendence arrows appear.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint