How to use Spreadsheet Formula Dependency Visualizer
- Choose a macro-free XLSX workbook within the stated file and worksheet limits.
- Select Formula references, Circular reference groups or Broken or unsupported references.
- Run the analysis and inspect the cells in the chosen view. Blank cells on an existing sheet are valid reference targets.
- Download the SVG graph, full JSON analysis or CSV for the selected view. Check unsupported syntax and dynamic references in the original spreadsheet application.
Example: Spreadsheet Formula Dependency Visualizer
Inspect an eight-formula workbook with a C1/D1 cycle and a valid reference to blank A99.
Supported inputs and limits
- One XLSX workbook up to 20 MiB compressed, 32 MiB expanded, 1,000 parts, 20 sheets and 100,000 stored cells.
- Dependency analysis accepts at most 1,000 formula cells and expands supported ranges up to 5,000 cells.
- No formula is evaluated or external resource fetched.
- Shared, array, data-table, structured, external, 3D, whole-row/column, defined-name and dynamic INDIRECT/OFFSET references are flagged rather than expanded.
- JSON and SVG retain the full bounded analysis;
More details
CSV follows the selected view.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved 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.