Trace formula
trace_formulaAudit Excel formulas by tracing precedents, dependents, and evaluation steps, including unresolved INDIRECT references. Use it to see which cells feed a formula or which formulas rely on a range.
Instructions
Audit formulas, calculated here. cells: ranges by sheet (names and table
references resolved); unknown: formulas with references that cannot be worked out (a
computed INDIRECT); steps: innermost first; more: results left out.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| range | Yes | A cell; a range for 'dependents'. | |
| sheet | Yes | ||
| direction | Yes | 'precedents': what the formulas use; 'dependents': formulas using `range`; 'evaluate': Evaluate Formula steps. | |
| all_levels | No | Follow to the end, not one level. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| more | No | ||
| cells | No | ||
| steps | No | ||
| unknown | No |