# Check broken, error & unused named ranges in your Excel file, free.

> Check an Excel workbook for broken, error and unused defined names, free. Runs entirely in your browser; your file is never uploaded.

Page: https://formulaudit.com/free-tools/excel-named-range-checker

A free browser tool from Formula Audit XL. No data leaves your machine. Open the page, drop an .xlsx, .xlsm or .xls file on it, and read the score and the list of flagged cells. Export a plain-text report, or install the add-in to catch the same issues live inside Excel.

## What this tool checks

- **Broken names**: the reference contains #REF!, usually because the cells it pointed at were deleted.
- **Error names**: the name resolves to an error such as #NAME? or #DIV/0!.
- **Unused names**: defined but never referenced in a formula or another name.
- Sheet-scoped and workbook-level names are both checked. Built-in names such as print areas are ignored.

## FAQ

### Is my Excel file uploaded anywhere?

No. The checker runs entirely in your browser using your device's memory. Your file and its contents never leave your machine, so it is safe for confidential models.

### What counts as a broken name?

A defined name whose reference contains #REF!. This happens when the cells a name pointed at were deleted, so any formula using that name now fails.

### How do you decide a name is unused?

The tool scans every formula in the workbook and the reference of every other name. If a name is never referenced anywhere, it is reported as unused. Unused names are clutter and a common source of confusion during a review.

### Do you check sheet-scoped names?

Yes. Names local to a single sheet and workbook-level names are both checked, and the report shows each name's scope. Built-in names such as print areas and filter ranges are ignored.

### What file formats are supported?

Modern Excel files (.xlsx and .xlsm) work best. Legacy .xls is also supported. Password-protected files cannot be read.
