Excel
Formula Auditing
Provides a hierarchical, interactive view of a formula’s precedents and dependents for efficient debugging and dependency analysis
How To Use Formula Auditing
- Step 1: Select the cell containing the formula you want to audit
- Step 2: Click the “Formula Audit” tool on the SkySuite ribbon
- Step 3: Expand or collapse items in the hierarchy to explore nested references
- Step 4: Select the target cell to review its references, validate formula dependencies, or identify errors
- Step 5: Click “OK” to close the tool when finished