Formula Trace Tool for Excel 2007
Last week I upgraded my formula auditing add-in to work with Excel 2007. To recap, the Formula Trace Tool allows the auditor to click on precedent or dependent cell references in a listbox as opposed to clicking on audit arrows or performing a manual search. The goal of this functionality is to allow the auditor to move through formulas much more quickly and efficiently.
When the add-in is installed, a button containing an orange diamond appears on the right side of the Formulas ribbon tab. If interested, more information on how to use the tool and a link to download it can be found here.
Posted on Monday, October 19, 2009 |
Comments (0) |
Permalink
