How to use this office tool
- Choose an Excel workbook that contains formulas.
- Start the dependency scan.
- Review detected paths and download the XLSX warning report for follow-up.
#240 · Formula & Cell Inspection Tool
Spreadsheet Circular Reference Warning
Inspect Excel formulas for direct and multi-cell circular reference paths, then export a workbook report with the cells involved in each detected cycle.
Office File Tool
One workbookrow
rows
Ad space
What this tool does
The checker builds a dependency graph from A1-style references in formulas and searches for cycles within each workbook. It warns about likely circular paths without recalculating formulas.
Formula references → dependency graph → cycle detection → XLSX warning report
Named ranges, structured references, external workbooks, and dynamic references such as INDIRECT may require manual review.
Supported formats
Files are processed locally. XLSX and XLS workbooks are read with SheetJS; CSV and TSV files are parsed with delimiter-aware handling. Advanced Excel features may not be preserved in generated files.
| Format | Support |
|---|---|
| XLSX / XLS | Read workbook values and formulas |
| CSV / TSV | Read delimited rows |
| Output | New downloadable file or report |
Tips for better results
- Work from a backup when the source workbook is important.
- Keep identifiers such as ZIP codes and account codes stored as text.
- Review the bounded preview and downloaded result before replacing any business workflow.
FAQ
Can this checker find indirect circular references?
It can find multi-cell cycles expressed with ordinary A1-style references, including references between worksheets.
Does it calculate formulas to confirm Excel's warning?
No. It analyzes formula references and does not reproduce the Microsoft Excel calculation engine.
Are named ranges and table references supported?
They are not resolved reliably in this browser version and should be inspected manually.
Can INDIRECT or OFFSET dependencies be detected?
Dynamic references created at calculation time may be missed because their targets are not explicit in the formula text.
What does the downloaded warning report contain?
It lists each detected cycle, its length, and the ordered workbook cells involved in the path.
Related office tools
Processing details
| Stage | Action |
|---|---|
| Input | One workbook |
| Privacy | Local browser processing |
| Result | New downloadable output |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all