Excel Shows an External Link You Cannot Find

Finding an external workbook in Excel’s link list is only the first step. Before removing it, find the cells or objects that depend on it. A report intended for continued editing needs those calculations preserved; a finished report may need a fixed set of values instead.

In a Microsoft community question, a user searched all workbook formulas for an external reference and found nothing. After locating the link list, they still wanted to know what was linked before breaking it. That question came from a Mac user. The navigation below is for Microsoft 365 Excel on Windows, with the relevant web difference noted separately.

Find the source and its cell references

Open Data → Queries and Connections → Workbook Links. Select a listed source and use Find next to locate references. Older Excel interfaces used Edit Links. An empty query list does not establish that no formula points to another workbook.

For a formula search, press Ctrl+F → Options, enter .xl, set Within to Workbook and Look in to Formulas, then choose Find All. Those are the settings in Microsoft’s link management instructions. Searching displayed values or just the active sheet can miss a reference.

Consider this illustrative price reference: ='[Rates.xlsx]Prices'!$B$2. It reads B2 on the Prices sheet in Rates.xlsx. Microsoft’s workbook link documentation explains the source and destination relationship. The destination contains the formula; the source supplies the value.

Record each location with its purpose: “order sheet, C2, unit price” is more useful than a filename alone. Follow the price into its dependent calculation. If the amount is wrong after your changes, that record tells you which input and formula to compare.

Look beyond worksheet formulas

A formula such as =B2*UnitPrice contains no external filename. The reference may be inside the definition of UnitPrice. Open Formulas → Name Manager and examine Refers To and Scope. A name can represent a range, a constant, or a formula, and its scope can be a worksheet or the whole workbook.

The Name Manager documentation also gives a limitation: the dialog does not display hidden names or names defined in VBA. A clean visible list is therefore not proof that every possible name has been examined.

Check the report’s visual elements separately. A chart can use local values while its title still refers to a different file. Microsoft’s external links reference includes objects, chart titles, and chart series among the places where links occur.

For example, a copied chart might still get its heading from the old report even after its bars use the new table. Removing formulas from the table would not address that heading. Identify the linked element before deciding whether to redirect its reference, replace its content, or remove it.

Go To Special selects objects on the active worksheet. Inspecting those objects leaves charts and shapes on other sheets unchecked, even if your earlier formula search covered the whole workbook. Record the sheets and objects you have examined, then repeat the object check on the remaining sheets.

Reconnect a report that must keep working

If the source moved and the report still needs its data, use the source’s more options (…) → Change source command in Workbook Links. Select the intended replacement. Then compare the referenced sheet and cells with the report’s requirements.

A matching filename is insufficient. In our example, Prices!B2 must contain the intended unit price. If a replacement file puts a discount percentage there, the reference could retrieve a value successfully and still produce the wrong amount. Check the item and its meaning, not just whether Excel reports a missing file.

Decide how many references should move before using Change source. The command in the link list changes references to that source throughout the destination workbook. Suppose earlier orders must keep reading the existing price file while one new order needs a different source. Select that order’s price cell and edit the external file reference in its formula bar instead of repointing the source for the entire workbook. Then check an earlier order and the new order against their intended source files, sheets, and cells. Microsoft describes both scopes in its source-changing instructions.

Moving files does not invariably break their links. Microsoft’s path storage explanation describes relative references that remain intact when the files keep their positions relative to each other. Sending the destination alone to another computer may not preserve that arrangement.

For a continuing handover, establish where the recipient will obtain the source. If it stays on an organizational share, check that the recipient can open it. A path on your own computer does not provide them with the underlying file. If the source cannot accompany a finished report, a separate static copy may fit the delivery requirement.

What stops calculating when you break a link

Breaking a source link replaces formulas using that source with their current results. Microsoft distinguishes the platforms: this operation cannot be undone on Windows, while Excel for the web allows undo. Save a working copy before preparing the fixed version.

Here is an illustrative order with quantity 10 and an external unit price of 25. Both designs initially produce 250:

The first design loses the multiplication as well as the external reference. The second separates the imported input from the calculation. That lets you freeze a price without freezing the effect of later quantity edits. Inspect the actual formula before treating “break link” as a way to lock only one input.

For selected cells, copy the range and use Paste → Values in the same location. Microsoft documents this as replacing a formula with its result. Other cells can still reference the same source, so the filename may remain in Workbook Links.

Values are also different from displayed text. A calculated value of 12.345 can appear as 12.35 because of formatting; replacing the formula retains the actual value. If delivery requires rounding to two decimal places, establish that rule separately rather than assuming link removal rounds the data.

When the warning survives your cleanup

Revisit names, objects, and charts if the alert remains after editing cell formulas. A query parameter can also use data from another workbook. Removing a worksheet reference does not establish that the query has lost its external input.

Do not delete a name simply because its definition mentions the old file. A retained formula such as =B2*UnitPrice still needs UnitPrice. Microsoft’s formula troubleshooting guide describes the #NAME? error caused by a missing defined name. Redirect the definition if the calculation is still required, or decide how to preserve its result before removing it.

Run Document Inspector through File → Info → Check for Issues → Inspect Document. It can report external links but cannot remove them automatically. Make the changes yourself and inspect again. Clearing this category does not establish that other hidden information has been removed.

If the reference remains unidentified, send the workbook’s author the source filename, your Excel platform, and the locations already checked. That gives them something specific to investigate before a broad cleanup deletes names or queries whose purposes are still unknown.

Check the working copy and the final report

For a repaired working copy, compare the imported value with its source and exercise the retained calculation in a disposable copy. In the order example, quantity 10 should produce 250 and quantity 12 should produce 300. A file whose amount formula was replaced may pass the first comparison and fail the second.

For a fixed report, record the data’s effective date and compare the totals, chart values, and headings with that snapshot. Save and reopen the delivery copy to check its link list and warnings. Keep next month’s template with the working files rather than starting from the static deliverable.

A visible number does not always indicate a successful refresh. Under the file-type blocking change effective from October 2025, an existing blocked link can retain its last successfully refreshed value. A newly created link can show #BLOCKED. Read the failure information in Workbook Links if the displayed result is unexpectedly old.

Globally enabling external content does not locate a reference. Microsoft’s external content controls govern trust in content outside the file. For an unfamiliar source, establish its owner and purpose before allowing a refresh.