Audit Links in Excel: Find and Check Workbook Links

How-to basics · Updated November 21, 2026

To audit links in Excel for Microsoft 365 on Windows, check both external workbook references and clickable hyperlinks: use Data > Workbook Links to review linked files, then search formulas and inspect hyperlink destinations. They are different kinds of links, so a complete review checks each separately before you update, remove, or trust anything.

What “links” means in an Excel workbook

People use “links” to describe several features in Excel. The first is an external workbook reference: a formula in one file reads a value from another workbook. A formula might refer to a source file named Sales.xlsx and a cell on its January sheet. If the source file is moved, renamed, unavailable, or changed, the destination workbook may show old values or ask to update links.

The second kind is a hyperlink. A cell, shape, or image can open a web page, an email address, or a location in a file or workbook. A hyperlink can look like ordinary text, so its appearance alone does not confirm where it leads. Excel also connects to data through Power Query, connections, and linked data types. Those connections matter in a broader data audit, but they are not the same as a formula link to another workbook or a clickable hyperlink.

Start by deciding what the review is meant to establish. A workbook-link audit asks which other files supply formula values and whether those sources are expected. A hyperlink audit asks whether clickable destinations are correct and safe. A wider workbook review may also need to inventory queries, connections, names, macros, and hidden sheets.

Review external workbook links

Open the workbook in the desktop version of Excel and select Data > Workbook Links. In Microsoft 365 for Windows, the command opens a pane that lists detected linked workbooks and provides actions for managing them. The exact placement or availability can vary with the Excel build and ribbon layout. If the command is not visible, check that the file is open in desktop Excel and consult the Data tab or search the ribbon for Workbook Links.

For each listed source, record its name and location, whether Excel can access it, and whether it is expected to supply current data. Use the pane’s available options to inspect or update a link only when you know the source is appropriate. If Excel asks whether to update links when opening a file, do not treat the prompt as proof that the source is trustworthy. Verify the file location and source owner first.

Workbook links can be easy to miss when a source is used in a formula rather than displayed as a visible URL. They may also occur in defined names or other workbook content, so the pane should be one part of the audit, not the only check. A linked workbook can be unavailable while cached values remain visible; seeing a plausible number does not establish that the current source was successfully read.

Search formulas for hidden references

Search the workbook’s formulas for external-reference patterns as a second check. On Windows, choose Home > Find & Select > Find, enter an opening square bracket, and select Options. Set Within to Workbook and Look in to Formulas, then search. In many external workbook formulas, the source file name appears in square brackets. Review each result in context rather than assuming every bracket means an external link: structured table references and other formula syntax can also contain brackets.

On Windows, Ctrl+F opens Find; on Mac, use Command+F. The Find dialog’s options and ribbon arrangement can differ on Mac, but the principle is the same: search formulas across the workbook, not just the current sheet. Searching for a known source filename or file extension can help confirm results, but it will not catch a source whose name you do not know or a reference stored outside ordinary cell formulas.

Also inspect defined names. Select Formulas > Name Manager and review the Refers to entries, especially names that point to a different workbook or an old file path. Names may be used in formulas, charts, or validation rules, and a name can keep a stale reference alive even if a visible cell formula does not expose it. If you find a suspect name, identify what depends on it before editing or deleting it.

Check hyperlinks and their destinations

Hyperlinks are not necessarily external workbook links. A hyperlink may send someone to a website, open a local document, start an email, or jump to a place inside the same workbook. To inspect an individual cell hyperlink, right-click the cell and choose Edit Hyperlink, or select the cell and use Ctrl+K on Windows. On Mac, Command+K is the usual shortcut. Read the displayed address or location before changing it; the text shown in the cell may not match the destination.

Inspect hyperlinks in shapes and images as well as cells. Select the object and use its context menu or the link-editing command available for that object. Buttons on a dashboard are a common example: the label may say “Open current report” even though its destination is an older file. For a large workbook, make an inventory of sheets and objects to review so that a manual check does not stop after the first visible worksheet.

Do not rely on Find to locate every hyperlink. Find is useful for searching visible labels or formula text, but a hyperlink’s destination may be stored separately from the cell’s displayed text. A cell that says “Policy” could point to any address, and a HYPERLINK formula may construct a destination from other cells. If you find such a formula, inspect the referenced cells and resulting address as well as the label. For a large or controlled audit, document the method used to enumerate hyperlinks, rather than assuming a text search found them all.

Trace dependencies and verify behavior

Finding a link tells you that a reference exists; it does not tell you how important it is. Select a formula cell and use Formulas > Trace Precedents to show cells or sources that feed it. Use Formulas > Trace Dependents to see formulas that rely on the selected cell. The arrows can help establish whether a linked value contributes to a key total, a chart, or a report. Use Formulas > Remove Arrows to clear the tracing display when you finish.

For example, a monthly report might import a sales total from a separate workbook, then use that total in a quarterly summary. If the source file has been archived, the audit should determine whether the monthly value is intentionally frozen or whether the report is expected to refresh. Compare the source and destination values, check the relevant dates, and confirm the intended owner or process. A link that opens successfully can still point to the wrong version of a file.

Test uncertain links on a copy of the workbook. If you update a source, compare important outputs before and after and investigate unexpected changes. Excel’s Formulas > Error Checking tools can help identify formula errors, but a link that returns a valid yet outdated value may not produce an error. Human review of dates, totals, and business meaning is still necessary.

Power Query and other data connections

A workbook can depend on external data without using a conventional linked-cell formula. To review queries and connections, select Data > Queries & Connections. Inspect query names, source details, load destinations, and refresh behavior. A query may read a file, database, folder, or online source; its presence does not mean that the Workbook Links pane will list it as an ordinary workbook formula link.

Check whether refresh is manual or automatic and whether the expected source is accessible to the people who use the workbook. Credentials, permissions, network paths, and privacy settings can affect whether a refresh succeeds. Do not enter or share credentials just to make an unfamiliar connection work. Confirm the source with the workbook owner or your organization’s data administrator, and use the appropriate approved access method.

Charts, PivotTables, data validation, and conditional formatting can also rely on ranges or names that deserve review. They are not all external links, but they can make a workbook appear incomplete if a source range changes. For a material report, check the input paths, refresh steps, and outputs that users actually consume—not just the presence or absence of a link warning.

Fixing, breaking, or retaining a link

Fix a link only after identifying the correct source and confirming that the destination workbook should use it. If the source has moved, use the management options in Data > Workbook Links to change or update the source where available, then verify key results. If the source is intentionally unavailable, decide with the workbook owner whether the workbook should retain its last values, be redesigned, or continue to reference that source.

Breaking a workbook link is a consequential change. Excel may replace linked formulas with their current values, removing the live relationship to the source. Those values will no longer update when the source changes, and the conversion may be difficult to reverse. Save a separate copy first, note the affected formulas, and verify the resulting workbook. Do not break links merely to suppress an update prompt.

Hyperlinks require a different repair: edit the hyperlink address or remove the hyperlink if it is no longer appropriate. Changing the visible label alone does not change its destination. After a repair, click or otherwise verify the destination in a safe way, especially for external websites or files. Avoid opening an unexpected download or enabling external content simply because a workbook contains a link.

Common problems and safe audit practices

  • The source cannot be found: The file may have been moved, renamed, or stored on a drive that is unavailable. Confirm the intended location instead of guessing a replacement.
  • The displayed value looks current: It may be a cached result. Check the last refresh or update context and compare against the authoritative source.
  • The search finds many bracket characters: Some are structured references, not links. Inspect the full formula and source name before taking action.
  • A link is not listed where expected: It may be a hyperlink, a defined name, a query, or another connection type. Check the relevant feature rather than treating all links as one list.
  • A link opens a suspicious location: Do not follow it or enable content just to test it. Verify the destination with the workbook owner or IT team.

Keep an audit record with the workbook name, review date, link type, source or destination, business purpose, owner, and action taken. For a shared workbook, record whether links are expected to update and who maintains them. Save the reviewed version under a clear name and retain the original according to your organization’s document practices. This makes later changes easier to explain and helps distinguish an intentional external dependency from an abandoned one.

Frequently Asked Questions

How do I find all external links in Excel?
Start with Data > Workbook Links, then search formulas across the workbook for external-reference patterns and inspect Formulas > Name Manager. Also review Queries & Connections if the workbook imports data. No single check necessarily covers every link type.

How can I tell whether an Excel link is broken?
Check whether the source is accessible and whether Excel can update it, then compare important results with the authoritative source. A cached value can remain visible even when the source is unavailable, so appearance alone is not a reliable test.

Are hyperlinks and workbook links the same thing?
No. A workbook link usually means a formula references another workbook. A hyperlink is a clickable destination, such as a web page or file. Audit both if the goal is to find every way the workbook points outside itself.

Does breaking links delete the linked data?
Breaking an external workbook link commonly replaces linked formulas with their current values, so the values remain but no longer update from that source. Make a backup and check the results before using the command.

Can I audit links in Excel for the web?
Excel for the web can handle many ordinary workbook tasks, but link-management options may be limited or differ from desktop Excel. For a full review of workbook links and connections, open the file in desktop Excel and check the available commands for that version.

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.