# Find circular references, external links & hardcodes in your Excel file, free.

> Find circular references, external links and hardcodes in your Excel file, free. Runs entirely in your browser; your file is never uploaded.

Page: https://formulaudit.com/free-tools/excel-circular-reference-finder

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

- **Circular references**: a formula that depends on itself, directly or through a chain. Excel points you to one at a time; this tool lists every cycle across the whole model.
- **External links**: references to other workbooks that can silently change your numbers. Many hide in defined names and are not shown by Excel’s Edit Links dialog.
- **Hardcoded values**: numeric constants typed inside formulas (for example =B5*1.2) instead of living in a labelled input cell.

## FAQ

### Is my Excel file uploaded anywhere?

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

### How does it find circular references?

It reads the formulas in your workbook, reconstructs the dependency graph between cells, and detects cycles. This includes circular references that span multiple sheets, which Excel surfaces only one at a time.

### What counts as a “hardcode”?

A numeric constant typed directly inside a formula (for example =B5*1.2 or =SUM(A1:A10)+500). These are inputs that should usually live in a labelled cell, and they’re a common source of model errors.

### Which external links does it detect?

It flags references to other workbooks that appear in formulas and in defined names, including links that Excel's Edit Links dialog can miss.

### What file formats are supported?

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