Usually, yes: broken Excel links can often be repaired by reconnecting the workbook to its source file or correcting the link address. First identify whether the problem is an external workbook reference, a clickable hyperlink, or a data connection; each uses a different repair process.
What a broken Excel link means
People use “Excel link” to mean several different things. The distinction matters because a workbook formula that imports a value is not repaired in the same way as a hyperlink that opens a document. Excel can also connect to data sources such as text files, databases, and online services.
- External workbook reference: A formula in one workbook refers to a cell or range in another workbook. A missing source file, renamed sheet, or changed folder can stop Excel from retrieving the intended value.
- Hyperlink: Clickable text or an image opens a web page, file, email address, or location in the workbook. The destination can become invalid even if all formulas still work.
- Data connection or query: Excel retrieves or refreshes information from an outside source. A changed password, server, file path, or permission can prevent a refresh.
Excel’s messages are clues, not always a diagnosis. A warning that links cannot be updated points toward an external reference, while a click that opens an error page is more likely a hyperlink. A refresh error usually belongs to a query or connection.
How external workbook links work
An external reference stores information about the source workbook, the worksheet, and the cell or range being referenced. Excel may also retain the source file’s location. If the file is moved or renamed, Excel may no longer find it automatically. Links can also point to a file on a network share or a cloud location, where access depends on the current account and permissions.
For example, suppose a report workbook refers to cell B4 on the January sheet in Sales.xlsx, saved in C:\Reports. The formula in the report cell could be ='C:\Reports\[Sales.xlsx]January'!$B$4. This example assumes that Sales.xlsx is at that location and that January!B4 contains 1250; the linked cell displays 1250 when Excel can access the source and update the reference. The formula can remain in the report even if the source is unavailable, but Excel may show an old saved value or an update warning.
Opening a linked workbook does not always mean that Excel will update every reference immediately. Excel may ask whether to update links, and the choice can depend on workbook security settings and the source’s availability. A value displayed in a cell is therefore not proof that it is current; check the update status and source file when freshness matters.
Find the link that is causing trouble
In Excel for Microsoft 365 on Windows, select Data > Workbook Links to inspect external workbook links when that command is available. The pane lists linked files and may offer controls to change the source, update values, or break a link. Some Excel builds or older workbooks use Data > Edit Links instead. The exact controls can vary with the Excel version and workbook type.
If the link list does not make the problem obvious, search the workbook for references to file extensions or a distinctive source name:
- Press Ctrl+F, then select Options in the Find dialog.
- Set Within to Workbook and Look in to Formulas.
- Search for a source filename, such as Sales.xlsx, or for a file extension such as .xlsx. Review the matches rather than replacing text across the workbook.
On Mac, use Command+F for Find; the link-management command and available features depend on the Excel release, so look on the Data tab for Edit Links or Workbook Links. Excel for the web has more limited workbook-link management than the desktop app. If the web version cannot repair a source, open a copy in desktop Excel.
Links are not always limited to visible cell formulas. They may also be used in defined names, charts, objects, or other workbook elements. If Excel reports an external link but a search of ordinary cells finds nothing, inspect these less visible areas and the workbook’s link-management pane before concluding the link is gone.
Repair an external workbook reference
Start with the least disruptive repair: make the source workbook available at its expected location. If it was moved, restore it to the original folder or use the link-management control to change the source to its new location. If it was renamed, confirm the correct file before reconnecting; a different workbook with a similar name may contain unrelated data.
- Check access: Open the source file yourself. Confirm that the folder, network location, or cloud account is available and that you have permission to read it.
- Reconnect the source: In Workbook Links or Edit Links, select the affected workbook and use the available change-source or file-selection command. Choose the intended source file, then check whether the displayed values update.
- Check the sheet and cells: If the source opens but the reference still fails, confirm that the referenced worksheet and cells still exist. A renamed or deleted sheet can break a reference even when the workbook file is present.
- Save and reopen carefully: Save a copy after the repair, close and reopen it, and check whether Excel still reports a missing source. This can reveal a path or access problem that was temporarily hidden by a cached value.
If the source file no longer exists, ask the workbook owner for the correct version or locate an authorized backup. Replacing a broken link with a guessed file is risky: the formula may work while returning information from the wrong reporting period or dataset. If the source has been intentionally retired, decide whether the workbook should retain its last values or be rebuilt against a new source.
When the problem is a hyperlink
A hyperlink is a destination, not a formula that retrieves a value. Right-click the linked cell or object and choose Edit Hyperlink to inspect its address. Correct the web address or file path, or use the dialog to browse to the intended destination. To check a link without changing it, copy the address and compare it with the actual page or file location.
File hyperlinks commonly fail after a folder is reorganized or a workbook is sent to someone who does not have access to the same drive. A link to a local path on your computer will not automatically work on a colleague’s computer. For shared documents, use a destination that the recipients can access, such as an approved shared folder or the organization’s supported cloud link. Confirm the recipient’s permissions as well as the address.
On Windows, Ctrl+K opens the Insert Hyperlink dialog in many desktop Office applications, including Excel. On Mac, Command+K is the corresponding shortcut. If a hyperlink is merely the wrong destination, editing it is usually preferable to changing workbook formulas or breaking external links.
Check queries and other data connections separately
A refresh failure does not necessarily mean that workbook links are broken. To inspect queries and connections in Microsoft 365 for Windows, open Data > Queries & Connections. Review the query or connection’s status and error details. A query may need a corrected source path, current credentials, network access, or permission to reach the service. The repair depends on the source and how the workbook was built.
For a file-based query, verify that the file still exists at the path used by the query. For an online source, check whether the account is signed in and authorized. If the connection belongs to someone else, ask its owner or administrator about access before changing its settings. A successful refresh is a better check of current data than simply seeing numbers already displayed in the workbook.
Should you break the link?
Breaking an external workbook link is not the same as repairing it. Excel typically replaces linked formulas with their current values, so those cells no longer update from the source. This can be appropriate for a final, static report, but it removes the connection that made the workbook dynamic. It can also make it harder to trace where a number came from later.
Before breaking links, save a separate copy and check what depends on the source. In the link-management pane or dialog, select only the intended link and review Excel’s confirmation. Then inspect the affected cells and save the static copy under a clear filename. Do not break a link merely to dismiss an update warning if the workbook is meant to stay current.
Prevent links from breaking when sharing
Simple habits can reduce broken references, especially when several people edit or distribute a workbook:
- Keep the source workbook in a stable shared location and avoid renaming or moving it without updating dependent files.
- When handing off a workbook, include the source files or provide recipients with working access to them.
- Use clear filenames and folders so that the intended source is easy to distinguish from an older copy.
- For a report that must be portable and does not need live updates, consider saving a separate values-only copy after checking its figures.
- Document important sources and update expectations, particularly when a workbook is used repeatedly by a team.
Disabling link updates is not a general repair. It may prevent a prompt or automatic update, but it does not make an unavailable source file accessible or correct a stale destination. Treat unexpected requests to enable external content cautiously, especially for workbooks received from unknown senders.
Frequently Asked Questions
Why does Excel say it can’t update links?
Excel may be unable to locate or access a linked workbook, or the source may require permissions that are not currently available. Check the source path and access first, then use Workbook Links or Edit Links to inspect or change the source.
Why does a broken link still show a number?
Excel may display a value saved in the workbook from an earlier calculation or update. That displayed value does not confirm that the source is reachable or that the information is current. Verify the source and update status before relying on it.
How do I find external links in Excel?
Start with Data > Workbook Links, or Data > Edit Links if that is the command in your Excel build. You can also search formulas for a source filename or file extension, and inspect defined names or charts if the link list shows a source that is not found in cells.
Does breaking a link delete the source workbook?
No. Breaking the link changes the dependent workbook, usually replacing linked formulas with their current values; it does not delete the separate source file. The dependent workbook will stop retrieving updates through that link.
Why does my hyperlink work for me but not someone else?
The address may point to a local file or a folder the other person cannot access. Share a destination available to the recipient and confirm that their account has permission to open it.
Can I fix broken Excel links in a browser?
Some workbook tasks are available in Excel for the web, but link-management options can be limited compared with desktop Excel. If the browser does not expose the needed repair control, open a copy in the Microsoft 365 desktop app and use its Data tab.
Related
- Excel Green Highlight Row and Column: How to Turn It On
- Excel Green Color Code: RGB, Hex, and Theme Shades
- Excel German Number Format: Commas, Dates, and Currency
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel #REF! Error: Causes, Fixes, and PreventionA #REF! error in Excel means a formula contains an invalid cell reference: Excel can no longer find…
- Excel Workbook Won’t Scroll? Fix Frozen or Stuck Sheets FastIf an Excel workbook will not scroll, first go to View > Freeze Panes > Unfreeze Panes, then…
- Outlook Find Related Messages Not Working? FixesIf Outlook’s Find Related command is missing or returns no messages, first check which Outlook version you’re using:…
- Excel Arrow Keys Not Working? Fix Scroll Lock and MoreIf the arrow keys move the worksheet instead of the selected cell, turn off Scroll Lock; on many…
- Excel Dollar Sign Shortcut: Fix Cell References in FormulasIn Excel for Microsoft 365 on Windows, press F4 while editing a formula and a cell reference is…
- Excel Data Table Not Calculating? Fix the SettingsIf an Excel what-if data table is not calculating, first check Formulas > Calculation Options and choose Automatic;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.