To fix broken links in Excel, first identify whether the problem is an external-workbook link in a formula or a clickable hyperlink. In Microsoft 365 for Windows, use Data > Workbook Links to inspect and change external workbook sources; for a clickable link, right-click it and choose Edit Hyperlink. Then verify the repair and save the workbook.
First identify what kind of link is broken
Excel uses “link” to describe more than one thing. The distinction matters because the tools for repairing them are different. An external workbook link connects a formula or other workbook content to a separate Excel file. A hyperlink is a clickable address that opens a webpage, file, email address, or location in a workbook.
- External workbook link: A formula might refer to a cell in another file, such as a sales workbook stored in a shared folder. If the source file is moved or renamed, Excel may report that it cannot update the link or may display old values.
- Hyperlink: A cell may show text such as “Open report,” but clicking it leads to a missing file or a page that no longer exists. The cell’s displayed text can remain correct even when its destination is not.
There can also be links in defined names, charts, queries, or other workbook features. A workbook can therefore appear free of broken links in one place while still containing a reference elsewhere. Start with the symptom: an update warning or an incorrect formula points toward an external workbook link; a failed click points toward a hyperlink.
Inspect external workbook links in Microsoft 365
Open the workbook in the Excel desktop app for Windows, then select Data > Workbook Links. The panel or dialog lists the external workbook sources Excel has detected and provides actions for managing them. The exact display can vary with Microsoft 365 updates and the workbook’s contents. If the command is unavailable, check that the file is open in desktop Excel and that it actually contains a link Excel recognizes.
Select a listed source to review its status and available actions. Depending on the source and Excel build, you may be able to update values, change the source, or break the link. If Excel asks whether to update links when opening the file, do not accept automatically unless you recognize and trust the source. An update can retrieve information from another workbook; investigate an unfamiliar source first.
Older Excel releases may show Data > Edit Links instead of Workbook Links. That older command offers similar source-management options. In Excel for Mac, link-management labels and available controls can differ by release; look on the Data tab for Workbook Links or Edit Links. Excel for the web has fewer link-management features than the desktop app, so open the file in desktop Excel if you cannot make the needed repair in a browser.
Change a missing workbook source to its new location
If the source file still exists but has been moved or renamed, changing the source is usually the best fix. First locate the correct workbook using File Explorer, a trusted shared drive, or the location supplied by its owner. Check the filename and folder carefully; similarly named files may contain different or outdated data.
- In the affected workbook, select Data > Workbook Links, or Data > Edit Links in a version that uses the older command.
- Select the source that Excel cannot find, then choose Change Source if that action is available.
- Browse to the correct workbook and select it. If Excel asks which file to use, verify the full path and name before confirming.
- Use the update action, if offered, and inspect several dependent cells to confirm that values now come from the intended file.
- Save the workbook, close it, and reopen it to check that the link remains valid.
For example, a formula may refer to a workbook in a former folder such as a department share that has since been reorganized. Pointing the source to the approved replacement folder may restore the formulas without changing each formula individually. If the source file is unavailable, ask its owner for the current version rather than selecting a file merely because its name looks similar.
A repair can still fail if the source workbook has been renamed internally, its relevant sheet has changed, or the referenced cells no longer contain the expected data. Changing a file path does not guarantee that the source’s structure or meaning is unchanged. Review important totals and sample records after updating.
Repair a clickable hyperlink
For a broken link in a cell, right-click the cell and choose Edit Hyperlink. In the dialog, correct the address or file path and confirm. You can also select the cell and press Ctrl+K on Windows to open the hyperlink editing dialog. On a Mac, Command+K is the common equivalent; menu labels and dialog details can differ by Excel version.
For a web link, check the complete address, including the correct website and page path. For a file link, browse to the file’s current location rather than typing a path from memory. If the link should jump to another sheet or cell in the same workbook, choose the option for a place in this document and select the intended destination. Test the link after editing it.
If the link is attached to a shape, picture, or other object instead of a cell, select the object and look for its link-editing command in the right-click menu or on the Insert tab. The exact controls can depend on the object and Excel version. Do not delete the object simply to remove a bad destination if it contains useful content; edit or remove only the link.
When a hyperlink is generated by a formula, changing the displayed text alone will not fix its destination. Inspect the formula in the formula bar and correct the address or the cell reference that supplies it. If you replace a formula with a manually entered hyperlink, consider whether the original formula was designed to update the destination automatically.
Search for references Excel did not list
If the Workbook Links panel does not explain the error, search the workbook for likely external-reference text. Press Ctrl+F on Windows, choose Options, set Within to Workbook and Look in to Formulas, and search for a distinctive part of the source name or an opening square bracket. External workbook references commonly include a workbook filename in square brackets. On Mac, use Command+F to open Find, then set the search scope and content options where available.
Search results are clues, not a complete audit. Review each result before editing because square brackets can occur for reasons other than the link you are trying to fix. Also inspect Formulas > Name Manager for defined names that refer to another workbook. A name can be used in formulas without the external path appearing in the visible cell text.
Other places worth checking include chart series, data validation lists, conditional formatting rules, and queries or connections. Their management controls are separate from the Workbook Links panel. For example, a chart may still use an old range even after the formulas in the worksheet have been corrected. If you find a reference in one of these features, edit that feature’s source rather than changing unrelated worksheet cells.
Why links break and how to prevent it
External links often break after a workbook is moved, renamed, or copied to a different folder structure. They can also fail when a network share is disconnected, cloud permissions change, or a source workbook is replaced with a file that has a different name. Hyperlinks break when a webpage changes its address or a linked file is moved or deleted.
Reduce future repairs by keeping related workbooks in stable, managed folders and agreeing on whether filenames may change. When sharing files, confirm that recipients can access the source workbook as well as the workbook containing the link. A link that works on one employee’s computer may point to a personal folder that nobody else can open.
- Use a shared location with consistent access permissions for files that must remain linked.
- When reorganizing folders, check dependent workbooks and update their sources as part of the move.
- Keep a note of the source workbook’s owner and purpose, especially when the link supports a recurring report.
- Test important hyperlinks and workbook links after sharing or moving a file.
- Make a backup before changing many links or removing links you may later need.
Relative and absolute file locations can behave differently when files are moved or shared, and Excel’s handling depends on how the link was created and where the workbooks reside. Do not assume that sending only the destination workbook will preserve its external data. If the workbook must be portable, consider consolidating required data into it or using an approved shared data source instead of relying on someone’s local file path.
When to break a link—and when not to
Breaking an external workbook link is not the same as repairing it. The break-link action generally replaces formulas that refer to the source with their current calculated values, removing the live connection. The values may remain visible, but they will no longer update when the source changes. This can be appropriate for a final, static report, but not for a workbook that must keep recalculating from the original data.
Make a copy before breaking links. Afterward, inspect key cells and formulas; Excel’s Undo history may not be a dependable way to restore a removed connection, particularly after saving or closing the workbook. If you need a working relationship between files, change the source or restore access to the original workbook instead. If you only need a snapshot, document when the values were captured and where they came from.
Frequently Asked Questions
Why does Excel say it cannot update links? Excel may be unable to find the source workbook, access its folder, or read a compatible source. Confirm the file’s current location, name, and permissions, then use Workbook Links or Edit Links to change the source if needed.
How do I find all external links in an Excel workbook? Start with Data > Workbook Links. Then search the entire workbook with Find set to look in formulas, and inspect Formulas > Name Manager. Check charts, queries, and other features separately if the issue persists, since not every reference is managed in one place.
Does breaking a link delete the displayed data? Usually, Excel replaces linked formulas with their current values, so the displayed results remain but stop updating. Because the formulas and live connection are removed, save a backup and verify the result before continuing.
Why does a hyperlink show correct text but open the wrong place? The text displayed in a cell is separate from the hyperlink destination. Edit the hyperlink address, or inspect the formula if the destination is generated by a formula, then click it to confirm the corrected target.
Can I fix workbook links in Excel for the web? Some link-related actions may be available, but the browser version has fewer management options than desktop Excel. If you cannot inspect or change the source there, open the workbook in Microsoft 365 desktop Excel and use Data > Workbook Links.
Verify the repair before relying on the workbook
After fixing a link, check more than whether the warning disappeared. Confirm that formulas return plausible results, hyperlinks open the intended destination, and any charts or summaries that depend on the data still look right. Save, close, and reopen the workbook to catch paths that only worked during the current session. For a shared workbook, ask another authorized user to test access from their own account or device. These checks help distinguish a repaired connection from a workbook that is merely displaying old cached values.
Related
- Excel Data Validation Lists: Create and Manage Dropdowns
- Excel Shuffle List of Names: 10 Easy Methods
- Excel: Find Where a Cell Is Used Across Sheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Freeze 2 Panes in Excel: What Works and What Doesn’tTo freeze two parts of a worksheet at once in Excel, select the cell just below the rows…
- Excel Open Shortcut Keys for Windows and Mac UsersIn Excel for Microsoft 365 on Windows, press Ctrl+O to open the Open screen, or press Ctrl+F12 to…
- How to Find the Indent Level in Excel Cells and Check ItTo find a cell’s exact indent level in Excel for Microsoft 365 on Windows, select the cell, open…
- Excel Row Limit: How Many Rows Can a Worksheet Hold?In modern Microsoft Excel, one worksheet can hold a maximum of 1,048,576 rows, numbered 1 through 1,048,576. That…
- Turn Off Conditional Formatting in Google SheetsTo turn off conditional formatting in Google Sheets, open the sheet in a browser, select Format > Conditional…
- Excel Blue Border Around Print Area: What It MeansA blue border around a worksheet in Excel usually means you are viewing it in Page Break Preview,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.