Power Formula Auditing: The Power Tool for every Excel User

Less-MultiPre
Every click reduces the arrows for the furthest level of precedents.
Less-MultiDep
Each click removes the arrows from the furthest level of dependents.
Erase Arrows.
This yellow “eraser” button removes all auditing arrows.
PowerFormulaAudit has a few limits.
·
For very big models, e.g., a thousand cells, the functions may take some
time to complete their job when the entire worksheet is selected. Excel’s
“Trace Precedents” avoids the time delay by limiting to only one
selected cell.
·
In rare cases, a formula may refer to an empty cell. For example, cell
A3 has this formula “=A1”, and cell A1 is empty (i.e., cell A1 has no
numeric value or string value, not even a space). Where an empty cell is
the precedent of another cell, the dependent arrow will not be drawn
with Multi-Dependent, e.g., when cell A1 is selected.. However, the
arrow will be drawn with Multi-Precedent, e.g., when cell A3 is
selected.

---

---

ABOUT THE AUTHOR
Dr. HC Chan has a PhD from the University of British Columbia. He has
teaching and research experience with spreadsheets. He taught a course on
decision modeling with spreadsheets, for a few years, at the National
University of Singapore. He also provided specialized training about
spreadsheet error detection to practitioners. His research about spreadsheet
users has been published at international journals and conferences.