- In short
- List formulas that reference another workbook to a range you pick. An external-link listing block. Your source data stays unchanged; Undo Last brings it back if needed. The whole operation happens locally; nothing is sent anywhere.
What it is for
List External Link Formulas is used to list only external-link formulas.
When to use it
Typical use: none.
Example scenarios
- None.
What it needs
A range + output cell. Supported data types: text, number, date (by selection).
How to use it
- Select the range to audit.
- On the XLMind Plus tab, open the Advanced Audit menu in the Formula Audit group and choose List External Link Formulas.
- Confirm; an external-link listing block.
What it produces
An external-link listing block.
Effect on your data and undo
List External Link Formulas does not change your source data; the result is added as a separate item. If it is not what you wanted, Undo Last restores the previous state.
How it differs from similar tools
Compared with a hand-built formula setup there is nothing to maintain; the source table keeps its formulas and formats untouched.
Good to know
No special preconditions.
Limitations
No special preconditions.
Frequently asked questions
- Where is the output written?
- An external-link listing block.
- Does the result stay linked to the source?
- The output does not track the source afterwards; a quick rerun brings it up to date.
- 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
- Before you start, consider Extract Formula Text
- To keep working on the result, use List Named Ranges
- A good companion is 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.