External link in a workbook

An external link is a reference from one workbook to a cell or a name in another file, so the value depends on a file the reader may not have.

External links survive edits to the target but not a rename, a move or a deletion, and Excel’s options can keep the last known value so a stale number looks current.

Inquire can map workbook links with a relationship diagram, which is the native way to see what a file depends on (Microsoft Support).

More definitions

Twenty-five terms a reviewer needs, each in one sentence followed by the context that matters.