Find Excel Workbook Links in Microsoft Excel

To find links to other Excel workbooks in Microsoft 365 for Windows, open Data > Workbook Links if that command is available, then inspect the listed sources. For a broader check, press Ctrl+F, search for [, choose to search within the workbook and look in formulas; external workbook references commonly include the source file in square brackets.

What an Excel workbook link is

A workbook link is a reference from one Excel file to information stored in another. For example, a monthly report might use a value from a separate budget workbook. The report can display the value while relying on that other file as its source. When the source workbook changes, Excel may offer to update the linked values the next time the report opens.

These links are different from ordinary hyperlinks. A workbook link brings data into a formula or chart from another workbook; a hyperlink is a clickable destination, such as a web page, file, or location in the current workbook. The two are often confused because both can point outside the file, but they are found and managed differently.

Links may be obvious in a cell formula, but they can also remain in defined names, charts, or other workbook features. A workbook can therefore contain a source link even when no visible cell seems to refer to it. Finding the link is the first step; you should then decide whether it is still needed and whether its source is trustworthy.

Check the Workbook Links pane

In current Microsoft 365 Excel for Windows, select Data > Workbook Links to open the pane when the feature is available. It lists detected linked workbooks and provides information and actions for managing them. The command or its available actions can vary with the Excel build and workbook state; if you do not see it, use the formula search below and check whether your Office installation is up to date.

For each listed source, note its file name and status before taking action. Depending on the link and Excel version, the pane may let you update values, change the source, or break the link. Updating asks Excel to retrieve values from the source; changing a source redirects the reference to another file. Breaking a link removes the external reference, commonly leaving the current value in its place. It does not preserve a live connection to the original workbook.

Do not treat the pane as proof that every kind of external reference has been found. A source list is useful for ordinary workbook-to-workbook links, but a workbook can also contain external destinations in features that require separate inspection. If a link matters for financial, operational, or reporting work, verify the relevant formulas and outputs rather than relying on one summary screen.

Search formulas for external references

Use Find to locate formulas containing the common external-reference marker, an opening square bracket. In Excel for Windows:

Press Ctrl+F to open Find. On a Mac, use Command+F.
Enter [ in the search box.
Select Options, set Within to Workbook, and set Look in to Formulas.
Choose Find All to list matches, or choose Find Next to inspect them one at a time.

An external reference often includes the source workbook name inside square brackets, followed by a worksheet and cell or range. If a workbook or sheet name contains spaces, Excel may display single quotation marks around part of the reference. The exact text can change when the source workbook is moved, renamed, or opened from a different location.

This search is a practical screening method, not a complete inventory. It can find formulas that contain the bracket marker, but it will not necessarily identify a hyperlink target, a chart setting, or every other feature that refers to an outside file. Also inspect the matches: square brackets may appear in text or in a formula for another reason, so a match is not automatically an external workbook link.

Look beyond visible cell formulas

If the search does not explain the behavior, check the places where a workbook can store references that are easy to overlook:

Defined names: Open Formulas > Name Manager and review the Refers to entries. A name may point to an external workbook even if it is not currently used in a visible cell.
Charts: Select a chart and inspect its data source and series. A chart can retain references to source data in another workbook.
Hidden sheets: Review the sheet tabs and, where appropriate, unhide sheets to inspect formulas. A hidden or very hidden sheet may hold supporting calculations.
Hyperlinks: Right-click a linked cell and choose Edit Hyperlink to inspect its destination. Search formulas for the function name HYPERLINK if links may have been created by formulas.
Objects and shapes: Select the object and inspect its link or action settings if clicking it opens a file or website.

Excel’s Find command searches cell content; it is not a universal search across every dialog and object in a workbook. Inspect the parts relevant to how the file is used. If a chart, name, or button is involved, test that specific feature after making a change.

Workbook links, hyperlinks, and data connections

It helps to identify what kind of link you have before trying to fix it. A formula link retrieves a value from another workbook. A hyperlink navigates to a destination when clicked; it does not, by itself, update a cell from that destination. A query or connection imports or refreshes data from a source such as a file, database, or web service. These are separate mechanisms and are not interchangeable.

For instance, a clickable link to a shared budget file is a hyperlink, even if the file is an Excel workbook. A report formula that reads a figure from that budget is a workbook link. A Power Query import from a folder of monthly files is a data connection. Each may require a different repair, and removing one does not necessarily remove the others.

When you see refresh prompts, identify the source before accepting. A prompt can relate to external workbook values or another refreshable feature. If the workbook came from someone else or an unexpected location, do not update blindly: a link may retrieve unintended or outdated data. Ask the file owner which source is authoritative or open the source independently from a trusted location.

Repair, update, or remove a link

Choose the action based on the workbook’s purpose, not simply because Excel reports a link. If the report should continue to reflect a separate source file, repair the path or source and confirm that the returned values are correct. If the source is intentionally frozen, you may choose not to update. If the source is obsolete, remove the reference only after checking what depends on it.

Update: Use this when the correct source is available and current values are required. Verify the source file and resulting figures.
Change source: Use this when the data has moved or the workbook should point to a replacement file. Check that the replacement has the expected sheets and structure.
Break link: Use this when live references are no longer wanted. Save a separate copy first and confirm that replacing formulas with fixed values is acceptable.
Leave it alone: This can be appropriate when the reference is deliberate but the source is unavailable. Document the limitation instead of silently changing reported values.

After a repair, recalculate or refresh as appropriate, then compare important results with the source. After breaking links, reopen the saved copy and check key sheets, charts, and reports. A result that looks unchanged at first glance may no longer respond to source updates, which is exactly what breaking the link is intended to do.

Common problems and limitations

A missing source file does not necessarily mean the displayed value disappears immediately. Excel may still show a previously saved value, even though it cannot refresh it. Treat that value as potentially stale until you verify when it was last updated and compare it with the source or an approved record.

A moved or renamed workbook can make a link appear broken. The source may still exist in another folder, but Excel may not find it at the stored location. Use the Workbook Links pane when available to inspect or change the source; do not recreate a link by guessing a path or selecting a similarly named file without checking its contents.

Another common misconception is that removing a hyperlink removes a workbook link, or vice versa. They are distinct. Deleting a clickable destination will not necessarily remove a formula reference, and breaking a formula link will not necessarily remove a button that opens the source file. If the goal is to remove all external references, check each relevant type separately.

Workbook behavior can also differ across platforms and versions. The steps here target Microsoft 365 Excel for Windows. Excel for Mac uses different keyboard shortcuts, as noted above, and ribbon availability can vary by release. Excel for the web has a different interface and may not offer every desktop link-management control; use the desktop app when a required command is unavailable online.

Frequently Asked Questions

How do I find all external links in an Excel file?
Start with Data > Workbook Links if it appears. Then search the entire workbook for [ with Find set to look in formulas. For a thorough audit, also inspect defined names, charts, hyperlinks, and objects because no single search covers every type.

Why can I not see Workbook Links on the Data tab?
The command can depend on the Excel build, workbook contents, and interface. Update Microsoft 365 if appropriate, and use Find with the workbook scope and formula setting as a fallback. If the file contains only hyperlinks or data connections, it may not have the kind of workbook link you expected.

How can I find links to another workbook in formulas?
Press Ctrl+F on Windows or Command+F on Mac, search for an opening square bracket, and set the search to the workbook and formulas. Review each result in context; the character is a clue, not conclusive proof that the match is an external link.

Does breaking an Excel link delete the source workbook?
No. Breaking a link changes the current workbook’s reference; it does not delete the separate source file. It can, however, remove the live formula connection and leave fixed values behind, so save a copy and verify that this is what you want.

How do I find a hyperlink in an Excel cell?
Right-click the cell and choose Edit Hyperlink to view its destination. If the cell uses a hyperlink formula, search formulas for HYPERLINK. For links attached to shapes or other objects, select and inspect the object separately.

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.