Tellsheet
Home › Excel Guides › Find External Links

How to Find External Links in Excel (When Edit Links Is Greyed Out)

You open a workbook and Excel announces that it contains links to one or more external sources. You go to Data → Edit Links to remove them, and the button is greyed out. You save, close, reopen — and the prompt comes back. The link is real. It is simply not in a place the dialog can see.

Last updated: November 2026

First, the two places it is not

Search this problem and you will be told that external links hide in data validation rules and conditional formatting rules. That advice is repeated everywhere and it is wrong.

We tested it against real Excel. Excel refuses to store a reference to another workbook in either one — directly, and also when you try the usual workaround of pointing the rule at a defined name that holds the reference. To be certain the refusal was Excel's and not a flaw in the test, we ran the same operation with a local reference: that one succeeds. So the behaviour is deliberate on Excel's part.

What people genuinely do hit in those rules is a reference to a deleted name or sheet, which shows up as #REF!. That is a real nuisance, but it is a broken reference, not a link to another file, and it is not what the external-links prompt is about. Ruling these two out saves you the hours most guides will send you down.

The three places a link really hides

  1. A cell formula — ='C:\Reports\[Budget.xlsx]Sheet1'!$A$1. The ordinary case, and the only one Find will help with.
  2. A cell formula on a hidden or very hidden sheet — the single most common reason Edit Links is greyed out. A very hidden sheet does not appear in the Unhide dialog at all, so there is no way to reach it by clicking.
  3. A defined name whose Refers to points at another file. It survives deleting every cell that used it, which is why the prompt outlives your clean-up.
  4. A chart series whose source range lives in another workbook — invisible unless you open Select Data on each chart in turn.

Finding each one by hand

Cell formulas

Ctrl+F, search for [, set Within to Workbook and Look in to Formulas. A link to another file always writes the file name in square brackets, so this catches every visible case.

Hidden and very hidden sheets

Right-click a sheet tab and choose Unhide. If the prompt persists after unhiding everything listed there, you have a very hidden sheet: press Alt+F11 for the VBA editor, select each sheet in the Project window, and set Visible to xlSheetVisible. Then run the Ctrl+F search again.

Defined names

Formulas → Name Manager. Widen the Refers to column and look for square brackets or a path. Delete the name, or repoint it at this workbook — but check nothing still uses it first.

Chart series

Click each chart, then Chart Design → Select Data, and read the series ranges. There is no search for this; it is one chart at a time.

The 1-click way (Tellsheet)

Link Inspector

Run Link Inspector and it writes a report to a new sheet: every reference to another workbook, which file it points at, exactly where it lives, and what to do about it. Sheets are reported with their visibility, so a link on a very hidden sheet is named as such — which is usually the whole answer to why Edit Links is greyed out.

It reports and never changes your file. It also lists what it could not examine on your version of Excel, so a quiet report never implies a clean bill of health it did not earn.

One honest limitation

On Excel for the web and Excel for Mac, add-ins are not given any way to read a chart's data source — Office's own API exposes the values a chart resolved to, never the reference they came from. So on those hosts Link Inspector checks formulas and defined names and says plainly that charts were not examined. Tellsheet for Windows can read chart series and does check them. We would rather tell you which stone was left unturned than let you believe there were none.

Frequently asked questions

Why is Edit Links greyed out when Excel says there are links?

The link is not in a place the dialog manages — most often a very hidden sheet, a defined name or a chart.

Can a link hide in data validation or conditional formatting?

No. Excel refuses to store an external workbook reference in either. That advice is a myth.

Will breaking links lose my numbers?

No — Break Link replaces each formula with the value it last fetched. You lose the connection, not the data.

Does Link Inspector change my workbook?

Never. It writes a report and leaves the file alone.

Related Excel guides

Find the link Excel will not show you

Link Inspector lists every reference to another workbook — including the one on the sheet you cannot see.

Get Tellsheet free See pricing