How Do You Find Linked Data in Excel?

You open a workbook you inherited from someone else and Excel greets you with a warning: this workbook contains links to one or more external sources that could be unsafe. You click through it, you look around the sheet, and you cannot see a single formula pointing anywhere unusual.

That is the problem with linked data in Excel. The link is real, but Excel does not show you where it lives. It can sit in a formula you never scroll to, in a defined name nobody has opened in years, in a chart title, or inside a shape on a sheet that is hidden.

This guide covers both things people mean when they search for linked data in Excel, because they are genuinely different features with different fixes. Then it walks through every place a link can hide, in the order that finds them fastest.

What Does "Linked Data" Mean in Excel?

There are two separate features, and knowing which one you are dealing with saves a lot of wasted clicking.

The first is a workbook link, also called an external reference or an external link. This is a formula in your workbook that pulls a value from a different workbook. It looks like `='C:\Reports\[Q3.xlsx]Sheet1'!$B$4` when the source file is closed, and like `=[Q3.xlsx]Sheet1!$B$4` when it is open. This is what triggers the security warning and the refresh prompts, and it is what most people are hunting for.

The second is a linked data type. These are the Stocks and Geography features on the Data tab. Microsoft's documentation describes them as pulling "in reliable data from online sources such as Bing." You type a company name or a country, convert the cell to a data type, and Excel attaches a whole record to it that you can pull fields out of.

Both are "linked data" in plain English. Only the first one is usually a problem.

Inheriting a workbook nobody documented is the spreadsheet version of inheriting a website nobody audited. Get a free SEO audit and see what is actually under the hood before you have to fix it.

The Fast Answer: Open the Workbook Links Pane

If you are running a current version of Excel, start here. Microsoft replaced the old Edit Links dialog with a side pane that is far better at this job.

Go to Data > Queries and Connections > Workbook Links.

The pane lists every external workbook your file links to. For each one you get its status, the option to refresh it, and a More Commands (...) menu with Change source and Break link.

Microsoft lists this as available in Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016. On older builds you are looking for Data > Edit Links instead, which does roughly the same job in a modal dialog.

Why the Pane Is Not the Whole Story

Here is the catch that sends people in circles. The Workbook Links pane tells you which files you are linked to. It does not tell you which cells are doing the linking.

So the pane is the right first step, because it tells you whether links exist at all and how many source files are involved. If the pane is empty, you can stop. If it lists three workbooks, you now know you are looking for references to three specific filenames, which makes the rest of the search much faster.

How to Find the Cells That Contain Links

Work through these five places in order. Between them they cover every location Excel will hide a reference.

1. Formulas: Search for the File Extension

Press Ctrl+F to open Find and Replace, then click Options to expand it.

• In Find what, type `*.xl*`
• Set Within to Workbook
• Set Look in to Formulas

Then click Find All. Every formula referencing an external `.xlsx`, `.xlsm`, `.xlsb` or legacy `.xls` file appears in the results list, and clicking a result jumps you straight to the cell.

Two variations worth knowing. Searching for `[` finds references where the source workbook is currently open, because that is the bracket syntax Excel uses. And if the Workbook Links pane gave you a filename, search for that filename directly rather than the wildcard. It is faster and it produces no false positives.

2. Defined Names

This is the one that catches almost everybody, because a defined name can point at another workbook without appearing in any visible cell.

Go to Formulas > Name Manager and look down the Refers to column. Any entry containing a file path or a bracketed filename is an external reference. Names like this often survive long after the formulas that used them were deleted, which is why a workbook can warn you about links while appearing to have none.

3. Objects and Shapes

Text boxes, shapes and images can all carry formulas.

Press Ctrl+G for Go To, choose Special, select Objects, and click OK. That selects every object on the active sheet. Click through them one at a time and watch the formula bar for an external reference.

4. Chart Titles

Click directly on a chart title and look at the formula bar. A title can be linked to a cell in another workbook, and nothing about the chart's appearance gives that away.

5. Chart Data Series

Select a data series in the chart and read the `SERIES` function in the formula bar. The arguments include the source range, and if that range sits in another file the path appears there.

Four things to check, in a fixed order, is how you stop guessing. The same discipline applies to search visibility — run a free audit and get the list instead of the hunch.

Do Not Forget the Hidden Sheets

Everything above searches the active sheet or the workbook, depending on the setting. Objects, in particular, are found per sheet.

Before you declare a workbook clean, unhide every sheet. Right-click any sheet tab and choose Unhide to see the normally hidden ones. Very hidden sheets, which were set that way in VBA, will not appear in that list at all and need the VBA editor to reveal.

A link sitting on a hidden sheet behaves exactly like a link on a visible one. It refreshes, it warns, and it breaks when the source moves.

Hidden sheets are where the surprises live, in spreadsheets and in site structure alike. Run a free audit and find the pages nobody remembers publishing.

How to Break Links You Do Not Want

Once you have found them, you have two reasonable choices.

Change the source if the link is legitimate and the file simply moved. In the Workbook Links pane, open the More Commands (...) menu next to the workbook and choose Change source, then point it at the new location. Every formula referencing that file updates at once.

Break the link if you want the numbers but not the dependency. Microsoft's description is precise about what this does: "When you break a link to the source workbook of an workbook link, all formulas that use the value in the source workbook are converted to their current values."

Two consequences follow from that sentence, and both catch people out.

First, your formulas are gone. Not disabled, not pointing somewhere else — replaced by the value they last returned. The logic is not recoverable from the cell.

Second, Microsoft states plainly that the action cannot be undone. Ctrl+Z will not bring the formulas back.

So the rule is simple: save a copy of the workbook before you break anything. If a stakeholder asks six months later how a figure was derived, the copy with live formulas is the only place that answer still exists.

When Linked Data Types Are What You Actually Want

If your search was really about Stocks and Geography, the mechanics are completely different and nothing above applies.

A cell that has been converted to a linked data type shows a small icon to the left of the value. Microsoft's documentation puts it this way: once converted, "an icon will appear in the left of the cell value." Click the icon, or press Ctrl+Shift+F5 on Windows or Cmd+Shift+F5 on Mac, to open the data card and see every field attached to that record.

A few requirements are worth knowing before you plan work around these.

You need to be signed in with a Microsoft account, and the feature requires an active Microsoft 365 subscription for the desktop app, with Excel for the web usable on a free Microsoft account. Microsoft also notes language restrictions for Stocks and Geography: English, French, German, Italian, Spanish or Portuguese.

Supported versions are Excel for Microsoft 365, Excel 2024, Excel 2021 and Excel for the web.

The Limitations That Matter

Microsoft documents three constraints that decide whether linked data types belong in a production workbook.

Older Excel versions cannot read them at all, and will show `#VALUE!` or `#NAME?` errors instead. If your file goes to anyone on an older build, this is a hard blocker.

Compatibility with PivotTables, Power Pivot and Power Query is limited. A data type that works beautifully in a flat range can stop cooperating the moment you try to model with it.

And converting a data type back to plain text breaks any formula that depended on it, because the fields those formulas pulled from no longer exist.

Linked Data vs the Alternatives

Workbook links are not the only way to get data from one file into another, and they are rarely the best one.

Power Query is the upgrade path for most recurring work. It connects to the source, applies your transformation steps, and loads a refreshable result. The connection is documented in the query itself rather than scattered across cells, which is the single biggest improvement over external references.

Consolidating into one workbook sounds crude and often wins. If two files always travel together and always refresh together, the link is overhead with a failure mode attached.

A shared data model — Power Pivot inside Excel, or a semantic model in a BI tool — is the right answer once more than two people depend on the same numbers. At that point the question is no longer where the link is, but who owns the definition.

The honest test is how many people would be stuck if the source file moved tomorrow. One person, a workbook link is fine. A department, and you have outgrown it.

If one broken path can take down your reporting, the problem is the architecture, not the link. Start with a free audit and find the single points of failure before they find you.

Common Mistakes When Hunting Links

A few patterns come up over and over.

Searching only the active sheet. Find and Replace defaults to the current sheet in some versions, so set Within to Workbook every time.

Searching for `[` and stopping there. That bracket syntax only appears when the source workbook is open. Closed sources show a full file path instead, which is why `*.xl*` is the better general-purpose search.

Ignoring the Name Manager. If the warning persists after you have cleaned every formula, this is almost always where the last reference is.

Breaking links before taking a copy. The one mistake on this list you cannot walk back.

Assuming a refresh error means the link is gone. A broken link is still a link — it still carries the path, it still warns, and it still needs removing properly.

Final Thoughts

The reason finding linked data in Excel feels harder than it should is that Excel treats links as a property of the file rather than something visible in the grid. The Workbook Links pane tells you the file is linked; it is on you to find where.

So work in the order that narrows fastest. Open the pane to learn which source files are involved and whether there are any at all. Search formulas for those specific filenames. Then check the three places that never show up in a formula search: defined names, objects, and chart elements. Unhide every sheet before you call it done.

And decide deliberately whether to repair the link or break it. Repair keeps the logic and the dependency. Breaking keeps the numbers and loses the reasoning, permanently, which is the right trade only when you are sure nobody will need to ask how a figure was produced.

If the workbook is becoming a maze of cross-file references, that is a signal rather than a nuisance. The workbooks that are hardest to audit are the ones doing a job they were never designed for. For a related piece of groundwork, our guide to what a data range is in Excel covers the foundation that most broken references are sitting on.