#119 · Formula & Cell Inspection Tool

Find Broken Cell References

Locate formulas containing broken #REF! references and export their sheet names, addresses, and formulas. The source stays on your device throughout the task.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Choose the supported source file.
  2. Review the worksheet and options that apply to this task.
  3. Select Find broken references, inspect the bounded preview, and download the newly created result.

What this tool does

Locate formulas containing broken #REF! references and export their sheet names, addresses, and formulas. It leaves the original file unchanged and produces a separate result for review.

Formula contains #REF! → CSV audit row

Browser libraries cannot reproduce every advanced Excel feature. Keep the original file and verify important output before relying on it.

Supported formats

The input formats below are supported for this focused browser workflow. Files over 50 MB are rejected to reduce browser memory pressure.

InputOutput
XLSX, XLSCSV report

Tips for better results

  • Keep an untouched copy of the source file.
  • Check the preview before downloading.
  • Open the result in your usual spreadsheet app and verify critical rows.

FAQ

What counts as a broken cell reference?

A formula containing the Excel #REF! error token is flagged.

Does this tool repair broken formulas automatically?

No. It creates an audit report so you can review each formula safely.

Are all worksheets scanned?

Yes. Every worksheet and every formula cell in its used range is checked.

Can it detect every possible formula problem?

No. It targets explicit #REF! tokens and does not run Excel's calculation engine.

What information is in the report?

The CSV contains worksheet, cell address, and the broken formula text.

Processing summary

StageBehavior
InputValidated locally
PreviewLimited rows
ExportNew file Blob

Browse more office tools

Office tool hubs