Why auditing may not help you check a cross-foot total
by Frank Kuhn and
Microsoft Excel 2000/2002/2003/2004/2007
Microsoft Windows, Macintosh
In the companion article “Set up your worksheet to warn you when row and column totals don’t mesh,” we show you how to use an IF formula and an error message to alert you when row and column totals don’t match. However, you may wonder why you can’t use Excel’s Auditing toolbar to solve the problem in our example.
The Auditing toolbar is useful when you need to check for mistakes in formulas or trace the connections between dependent cells (cells containing a formula that refers to other cells) and precedent cells (cells that contain a value used in another cell’s formula). While the Auditing toolbar may be perfectly appropriate for some situations, it isn’t always the perfect tool for the job.
As you can see by our original example’s audited formulas, as shown in Figure A