- In short
- Color formulas that reference another workbook. Colored external-link cells. Your table stays untouched, and Undo Last stands by if you change your mind. Everything runs on your computer, with no internet involved.
What it is for
Highlight External Link Formulas is used to highlight cells with cross-workbook link formulas.
When to use it
Most useful when you need to detect external links before sharing.
Example scenarios
- Detect external links before sharing.
What it needs
A range (whole col → used band). Supported data types: text, number, date (by selection).
How to use it
- Select the range to audit.
- Run Highlight External Link Formulas from the Formula Audit group on the XLMind Plus tab.
- Confirm; colored external-link cells.
What it produces
Colored external-link cells.
Effect on your data and undo
Highlight External Link Formulas writes the result over the cells you selected. One click on Undo Last brings everything back.
How it differs from similar tools
It applies a one-off, lasting mark without setting up conditional formatting rules; there is nothing to maintain and one step undoes it.
Good to know
No special preconditions.
Limitations
No special preconditions.
Frequently asked questions
- Where will I see the result?
- Colored external-link cells.
- Does the result stay linked to the source?
- What you get is static: it will not follow later edits, so rerun the tool once the data moves on.
- Any known limits?
- No special preconditions.
- Does it work offline?
- Yes. Everything runs on your computer; the internet is only needed for licensing and updates.
Works well with
- As a preparation step, try Highlight Error Cells
- To keep working on the result, use Formula Map Summary
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.