How to use Spreadsheet Formula Dependency Visualizer
- Choose a supported XLSX workbook.
- Inspect static references, cycles and unresolved sheet targets.
- Review unsupported-formula warnings before relying on the graph or exported edges.
Example: Spreadsheet Formula Dependency Visualizer
An XLSX sheet where A1 refers to B1 and B1 refers to A1.
Options
- Workbook
- Select a saved XLSX file. The graph reads stored formula text and static cell references rather than calculating a workbook.
- Unresolved references
- Review broken destinations separately from unsupported formulas. A reference to an unstored blank cell does not by itself mean the formula is broken.
Supported inputs and limits
Where your input is processed
This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.
Follow the graph back to the workbook
An edge runs from the formula cell to a referenced cell. A cycle shows that the entered formulas refer back to each other; it does not establish how the spreadsheet application handles iterative calculations. Dynamic references and other unsupported syntax stay unresolved. Use the cell names and exported graph to inspect those formulas in the original workbook.
Questions about Spreadsheet Formula Dependency Visualizer
Does the graph evaluate a formula?
No. It inspects supported static references.
Can INDIRECT or OFFSET be resolved?
Their runtime targets are not inferred. The affected formulas receive an unsupported-reference warning.
Does a missing cell always mean a broken reference?
No. A blank cell is a valid reference. Literal #REF! and missing sheet targets are reported separately.