How to Check External Links in Excel and Find Their Source

How-to basics · Updated November 20, 2026

To check external links in Excel, open Data > Workbook Links to review links to other workbooks. To find web hyperlinks, inspect the link on the cell or object without clicking it. These checks help you identify where a link points, whether it may need updating, and whether it is safe to keep. The steps below are for Excel for Microsoft 365 on Windows.

What You’ll Need

  • The workbook you want to inspect. If possible, work from a copy, especially before changing or removing links.
  • Access to the workbook or website that a link points to, if you need to verify that destination.
  • Excel for Microsoft 365 on Windows for the menu paths below. Some link-management options differ in older Excel versions, on Mac, and in Excel for the web.

Step-by-Step

  1. Save a working copy and decide what kind of link you are checking. Use File > Save As to make a copy before changing sources or breaking links. Excel uses the word “link” for different things. A workbook link is a formula that gets data from another Excel file. A hyperlink is a clickable cell or object that opens a web page, file, email address, or place in the workbook. External data connections, such as queries, are a separate category. Knowing which one you are looking for helps you choose the right check.
  2. Check the Workbook Links pane for linked Excel files. Select Data > Workbook Links. The pane lists external workbook sources Excel has detected and provides information and actions for them. Select a listed source to review its name and any available status or management options. Do not choose an update, change-source, or break-link action just to see what the link is. If the workbook opens with a prompt asking whether to update links, choose not to update until you have verified the source and trust it. A link can point to a file that has moved, been renamed, or is not available on your computer.
  3. Search formulas for external workbook references. Press Ctrl+F, select Options if needed, set Within to Workbook, and set Look in to Formulas. Search for an opening square bracket, [, then choose Find All. Many external workbook formulas include a file name in square brackets, such as ='[Budget.xlsx]Sheet1'!A1. Review the results and inspect each cell in the formula bar; a match might be unrelated text or another formula detail, so do not assume every result is a link. This search is a useful second check, not a guarantee that every kind of link has been found.
  4. Inspect a hyperlink without opening its destination. Select the cell, then look at the status bar or right-click the cell and choose Edit Link or Edit Hyperlink, if that option appears. The wording can vary by Excel build. The link dialog shows the destination; read it before deciding whether it is expected. A normal hyperlink may have friendly text such as “Open report,” so the displayed cell text alone does not identify where it goes. You can also select the cell and inspect the formula bar: a formula-based hyperlink may use HYPERLINK. Avoid clicking an unfamiliar link to test it, since doing so may open an unsafe or misleading site.
  5. Check links attached to shapes and pictures. A clickable link may be assigned to a button, image, chart, or other object rather than a cell. Right-click the object and look for Link, Edit Link, or Edit Hyperlink. If the right-click menu does not show a link option, the object may not have one. For a chart, also distinguish between a hyperlink on the chart itself and a chart series whose data comes from another workbook; inspect the chart’s source data and the Workbook Links pane for the latter.
  6. Look for less obvious references if the first checks do not explain the prompt. Select Formulas > Name Manager and review the Refers To entries for file paths or bracketed workbook names. Names can be used by formulas without being visible in the grid. If the workbook uses imported data, open Data > Queries & Connections and inspect the listed queries or connections; these may contact a database, file, or web service and are not the same as ordinary workbook links. Also review relevant chart series and formulas used by conditional formatting or data validation when you suspect a link is hidden in a particular feature.
  7. Verify the destination before updating or removing anything. Compare the source name or address with the file or site you expect. If a workbook link should point to a replacement file, use the available change-source option only after confirming the new file and saving a backup. If a link is obsolete, check what depends on it before removing it. Breaking an external workbook link can replace linked formulas with their current values, which removes the live connection and may be difficult to reverse. Removing a hyperlink, by contrast, usually removes the clickable destination but leaves the cell’s displayed text.

Common Mistakes

  • Confusing a hyperlink with a workbook link. A web address you can click is not necessarily listed in Workbook Links. Use the link dialog for hyperlinks and the Workbook Links pane for references to other Excel files.
  • Trusting the visible label. A cell that says “Company site” can link to a different address. Inspect the actual destination rather than relying on the displayed text.
  • Updating every link automatically. Updating may retrieve data from a file or location you have not verified. Decline the update prompt until you know what the source is and whether it is trusted.
  • Breaking links as a cleanup shortcut. This can convert formulas to fixed values, so results will no longer refresh from the source. Make a copy and confirm that static values are acceptable before using that action.
  • Assuming one search finds everything. Searching formulas for [ can help locate workbook references, but it will not identify every hyperlink, query, connection, or link assigned to an object.

Tips

  • Record the worksheet, cell or object, and destination for each unexpected link. That makes it easier to ask the workbook owner whether it is still needed.
  • Use Find All rather than opening matches one by one, and set the search scope to the whole workbook so you do not overlook another sheet.
  • Check a link’s full address carefully, including the folder path, file name, and web domain. Similar-looking names can refer to different files or sites.
  • If the workbook is shared, coordinate changes with its owner. A source path that fails on your computer may work for another person or a shared drive.
  • Keep a backup before changing sources, breaking links, or removing a group of hyperlinks. A copy gives you a straightforward way to compare results if formulas or displayed values change.

Troubleshooting

Workbook Links is not visible. Confirm that you are using the desktop version of Excel and check the Data tab. In some older Excel versions, the command is called Edit Links. Excel for the web may not provide the same full link-management controls; open the file in desktop Excel to inspect and manage workbook links. Menu availability can also depend on the workbook and Excel build.

The pane is empty, but Excel still shows a link warning. Check for a formula reference by searching the entire workbook with Look in: Formulas. Then review Name Manager and, if relevant, queries and connections. The warning may relate to an external data connection rather than a formula linked to another workbook.

A link appears broken or the source cannot be found. Check whether the source file was moved, renamed, stored on a drive that is disconnected, or saved in a location you cannot access. Ask the file owner for the correct current path. Do not point the link at a similarly named file without checking its contents; the workbook could otherwise display incorrect data.

You cannot see a hyperlink option when right-clicking. Make sure you selected the cell or object that actually carries the link, not a nearby blank cell or chart area. For a cell, check whether its formula bar contains a HYPERLINK formula. For objects, try selecting the object first and then right-clicking it. If you only need to read a destination, do not follow the link.

Excel says a link cannot be updated. The source may be unavailable, you may not have permission, or its path may have changed. Record the source shown in Workbook Links, confirm the correct file with its owner, and then update the source only if it is trusted. If you do not need live data, discuss whether keeping the last values is acceptable before breaking the link.

Frequently Asked Questions

How can I see all external workbook links in Excel?
Open Data > Workbook Links in Excel for Microsoft 365 on Windows. Search formulas for [ as a secondary check, and review defined names if you suspect a reference is not obvious in the worksheet.

How do I check where a hyperlink goes without opening it?
Select or right-click the linked cell and choose Edit Link or Edit Hyperlink, if available. Read the destination in the dialog and cancel without changing it. Do not click an unfamiliar link merely to test it.

Why does Excel say this workbook contains links?
The file may contain formulas that refer to another workbook. It may also have a defined name or another feature that refers to an external source. Check Workbook Links, formulas, and Name Manager before deciding whether the warning is expected.

Does breaking a link delete the source workbook?
No. Breaking a workbook link changes the formulas in your current workbook, commonly replacing them with their current values; it does not delete the separate source file. Make a backup first because the live connection is removed.

Are external links and data connections the same thing?
No. Workbook links commonly pull values through formulas from another Excel file. Data connections, including queries, retrieve information from sources such as files, databases, or web services. Check Data > Queries & Connections for connections that are not explained by Workbook Links.

Can I check external links in Excel for Mac or the web?
Excel for Mac has link-related commands, but their names and availability can differ by version; look on the Data tab for link-management options. Excel for the web has more limited management features, so use the desktop app when you need to inspect or change workbook links in detail.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.