What Is an External Link in Excel?
An external link in Excel is a formula that references a cell in a different workbook, so the value depends on a file that may not be open or available. They look like =[Budget.xlsx]Sheet1!$A$1 and are also called external references or workbook links. External links are a common source of broken and stale numbers.
How External Links Look and Form
An external link includes the source workbook name in square brackets, the sheet name, and the cell, for example ='[Q3 Model.xlsx]Inputs'!$B$4. When the source file is closed, Excel stores its full path so it can refresh the value later. These links are created the moment you reference a cell while another workbook is open, often by accident during copy and paste.
Because the link points at a separate file, the value you see is only as current as the last refresh, and it depends on that file staying in the same location with the same structure.
- Syntax includes the source file in brackets:
[Workbook.xlsx]Sheet!Cell. - Often created accidentally by copying cells between open workbooks.
- Excel stores the full file path so it can refresh when the source reopens.
Why External Links Cause Problems
External links are fragile. If the source workbook is renamed, moved, or deleted, the link breaks and Excel shows a prompt about updating links or a #REF! error. Even when the source exists, the receiving model may show stale numbers because it was last refreshed against an older version of the source.
They are also a confidentiality and reproducibility risk. A model that silently pulls from a file on someone's local drive cannot be reliably shared, audited, or reproduced by anyone who does not have that exact file.
- Broken links throw
#REF!when the source moves or is deleted. - Stale values appear when the source changed but was not refreshed.
- Models cannot be shared cleanly if they depend on hidden local files.
Finding and Managing External Links
Excel lists workbook links under Data > Edit Links (called Workbook Links in newer versions), where you can check status, update, or break a link. Breaking a link with that dialog converts the linked formulas to their current values, but it works link by link and does not always catch references buried in defined names or charts.
When you are finalizing a model to send out, the safest move is usually to convert external links to static values so the file no longer depends on anything outside itself.
Data>Edit Linksshows source status and lets you break links.- Breaking a link replaces external formulas with their last values.
- Hidden links can live in named ranges, charts, and data validation.
Converting External Links With ModelMint
ModelMint's Hardcode Links converts external links into their current values in one pass, so the workbook stops depending on outside files. This is exactly what you want before sending a model to a client or an investor, where stale or broken links would look careless and could expose where your source data lives.
It runs locally on Windows in Excel 2016 and later, with no telemetry, so the conversion happens entirely on your machine.
Hardcode Links
Convert external workbook links to static values so your file stands on its own.
Get ModelMint See how it worksFAQ
Where does Excel store external links?
In the formulas themselves, written as [Workbook.xlsx]Sheet!Cell with the source path remembered for refresh, and sometimes inside defined names, charts, or data validation rules.
How do I get rid of the update links prompt?
The prompt appears because the workbook references another file. Converting those external links to values removes the dependency. ModelMint's Hardcode Links does this in one pass across the workbook.
Does converting external links to values lose data?
It replaces the live link with the value currently shown, so the number stays but stops updating. That is usually what you want when finalizing a model to share, since it makes the file self-contained.