If an Excel link is not responding, first check whether it is a clickable hyperlink or an external-workbook link: for a hyperlink on Windows, hold Ctrl and click the cell, then check its address with a right-click and Edit Link; for workbook references, open Data > Workbook Links and review the link status. The right fix depends on whether Excel cannot open a destination or cannot refresh linked data.
First identify what kind of link is failing
Excel uses the word link for two different features, and mixing them up can send troubleshooting in the wrong direction. A hyperlink takes you somewhere when you follow it: for example, to a website, an email address, another cell, or a file. An external workbook link connects a formula to data stored in a different Excel file. It may update a value in the current workbook without opening the referenced file.
A useful first clue is what you expect to happen. If clicking a blue, underlined cell should open a webpage but does nothing, troubleshoot a hyperlink. If a value such as a sales total should change when another workbook changes, troubleshoot an external link. A cell can also contain a formula that produces a hyperlink, so its appearance alone may not reveal how it was created.
- Hyperlink problem: the destination will not open, the click selects the cell, or the destination is wrong.
- Workbook-link problem: Excel shows a warning, an old value remains, or a formula returns an error such as #REF!.
- Neither may be broken: a link might be waiting for a Ctrl-click, or Excel may be asking whether to trust an external destination.
Follow a hyperlink in Excel for Windows
In Excel for Microsoft 365 on Windows, the default behavior commonly requires Ctrl+click to follow a hyperlink. A regular click selects the cell so that you can edit or copy it. Hold Ctrl while clicking the linked cell. If that works, Excel was responding; the click behavior was the issue.
You can change this behavior in the desktop app by selecting File > Options > Advanced. Under Editing options, clear Use Ctrl+Click to follow hyperlink, then select OK. Afterward, an ordinary click follows the link, which can make editing linked cells less convenient. If you do not see the option, check that you are using the Windows desktop version rather than Excel for the web.
If Ctrl+click still does nothing, right-click the cell and choose Edit Link or Edit Hyperlink, depending on the wording in your version. Inspect the displayed destination. You can copy a web address into a browser to see whether the address itself works, or check that a file path points to a location you can access. To test whether the problem affects only one link, try another known, safe hyperlink in the same workbook.
On a Mac, Excel has different menus and click behavior from Windows. Command+K opens the Insert Link dialog in many current Mac versions; it is useful for inspecting or creating a link, not for proving that its destination works. If a click selects the cell instead of opening its link, use the cell’s context menu to inspect or open the hyperlink, and check Excel for Mac’s current editing preferences. Excel for the web uses browser-based clicking and does not provide the Windows File > Options dialog.
Check and repair a broken hyperlink
A hyperlink can be present but point to an outdated or malformed destination. A web page may have moved, a file may have been renamed, or a workbook may have been moved to another folder. Edit the link and compare its address with the current destination. For a website, include the complete address, including the https:// prefix when appropriate. For a file, confirm the name, folder, and extension, and make sure you have permission to open it.
File links are particularly sensitive to location. A link to a file on a colleague’s computer may work for that colleague but not for you. A link to a mapped network drive can also fail if the drive is not connected or is mapped under a different letter. Shared folders, SharePoint, and OneDrive can introduce sign-in or synchronization issues; confirm that the destination is available to your account rather than assuming the link itself is defective.
To repair the destination, right-click the cell and select Edit Link or Edit Hyperlink. Enter or browse to the correct destination, review any optional text or cell reference, and confirm the change. If the link points to another place in the same workbook, verify the sheet name and destination cell. Renaming a worksheet or deleting a target cell can make an internal destination invalid.
Links can also be attached to shapes, pictures, or text boxes rather than cells. Select or right-click the object and look for its link-editing command. Clicking the cell underneath an object may not activate the object’s link, and editing a nearby cell will not repair it.
Understand external workbook links and update prompts
An external workbook link is usually part of a formula that refers to a cell or range in another workbook. Excel may ask whether to update links when you open a file. That prompt is a trust decision as well as a refresh question: updating can retrieve current values from the source workbook, while declining may leave previously saved values in place. Do not update a link from an untrusted file or location just to dismiss a warning.
In current Microsoft 365 for Windows, select Data > Workbook Links to inspect external workbook connections when that command is available. The pane can show linked workbooks and provide controls to refresh or change a source. In some older Excel versions, the corresponding command is Data > Edit Links. The exact options vary by version and link type; Excel for the web may not offer the same management controls as the desktop app.
If a source workbook has moved, use the link-management controls to change its source to the correct file, if available. If Excel cannot find it, first verify that you can open the source workbook yourself and that it is not offline, renamed, or blocked by permissions. For cloud files, sign in to the account that has access and allow synchronization to finish. A workbook link is not the same as a hyperlink to the source file: opening the source does not automatically repair every reference to it.
A #REF! result often means a formula refers to a cell or range that no longer exists, or that a reference became invalid during a move or edit. A missing source file can cause other link warnings or stale values instead. Check the formula and source path before replacing formulas. Breaking a workbook link may replace formulas with their current values, removing the live connection, so make a copy before using that option.
Check security, permissions, and file location
Excel and Windows may warn about links that lead outside the workbook, especially links to files or locations that are not trusted. Such a warning does not by itself prove that the link is malicious or broken. It means you should verify who supplied the workbook and whether the destination is expected. If you do not trust the source, do not follow the link or enable content simply to make the warning disappear.
Protected View can open a file in a restricted state when it came from an internet download or another potentially unsafe location. If you trust the file, follow your organization’s security guidance before enabling editing. Protected View, file permissions, a sign-in requirement, and a broken address are different issues; changing security settings will not fix an incorrect URL or a missing file.
For a link to a shared drive, check that you are connected to the required network or VPN and can browse to the folder independently. For a OneDrive or SharePoint destination, confirm that the file has not been moved and that your account can access it. If only one person gets an error, account access or local synchronization is more likely than a workbook-wide link defect. If everyone gets the same error, the destination or link may have changed.
Use a quick troubleshooting sequence
Work from simple checks toward changes that affect the workbook. This helps distinguish a click-setting issue from a damaged link and avoids breaking a working external connection.
- Save a copy of the workbook if it contains important formulas or external references.
- Decide whether the link should open a destination or refresh data from another workbook.
- For a cell hyperlink on Windows, try Ctrl+click. If needed, inspect the address through the cell’s right-click menu.
- Open the destination separately, if safe, and confirm that the file, webpage, or shared location is available to your account.
- For workbook references, review Data > Workbook Links or, in some older versions, Data > Edit Links. Check the source path and update status.
- Test another link and, where possible, open the workbook in the desktop app. If one link fails, focus on that destination; if many fail, investigate access, network, application, or workbook-wide settings.
If the problem appears only in Excel for the web, open the workbook in the desktop app as a comparison, especially for links to local or network files. If it appears only on one computer, check sign-in, network access, and whether the same version and location of the workbook are being used. Avoid repeatedly changing Trust Center settings without identifying what is being blocked.
Prevent link failures when sharing workbooks
Before distributing a workbook, test its important links from the location and account the recipient will use. A link to a personal Downloads folder or a mapped drive may not exist for another person. For shared files, use a destination the intended readers can access, and communicate any required sign-in or permissions separately.
Keep source workbooks in a stable shared location before creating external references. Moving or renaming a source after linking can leave other workbooks unable to find it. If recipients only need a snapshot rather than live updates, consider sharing a copy with values instead of maintaining external links—but make that choice deliberately, because values will not refresh when the source changes.
For hyperlinks to websites, review the address after copying it from email or another document; a trailing punctuation mark or incomplete address can cause a failure. For internal links, avoid deleting or renaming the target sheet without checking the links that point to it. These small checks are especially useful in workbooks used as indexes, dashboards, or reference lists.
Frequently Asked Questions
Why does clicking an Excel link select the cell instead of opening it?
On Windows, Excel commonly follows a hyperlink with Ctrl+click. Hold Ctrl while clicking, or change the Use Ctrl+Click to follow hyperlink option under File > Options > Advanced if you prefer ordinary clicks.
Why is Excel not updating links to another workbook?
The source workbook may have moved, be unavailable, require a sign-in, or be blocked by your access permissions. Check Data > Workbook Links in current Microsoft 365, verify the source location, and update only if you trust the source.
Does #REF! mean my hyperlink is broken?
Usually not. #REF! is a formula error indicating an invalid cell or range reference. A clickable hyperlink has a destination address; inspect that address separately from any formula errors in the workbook.
Why does an Excel link work for someone else but not for me?
You may not have access to the destination, may be signed into a different account, or may not be connected to the required network or cloud service. Ask whether the link points to a shared location rather than another person’s local drive.
Is it safe to update links when Excel asks?
Only update links when you recognize and trust the workbook and its source. If you are unsure who created the file or where a link leads, decline the update and verify the source before proceeding.
Related
- Excel: How to Hide Column Lines and Gridlines on a Worksheet
- Excel Hide Column Letters? What the Setting Actually Does
- Excel Heatmap Table: How to Create and Read One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Why Is My TRANSPOSE Formula Not Working in Excel?Your Excel TRANSPOSE formula usually fails because its result cannot fit in the destination, it was entered using…
- Excel Error: Why You Can’t Change Part of an ArrayThe Excel message “You can’t change part of an array” means the cell you are trying to edit…
- Excel Merged Cells Not Showing in Filter? Fix the DataExcel filters do not treat a vertically merged cell as though its value were repeated in every row:…
- Excel Formula to Remove the #DIV/0! ErrorIn Excel, the quickest way to replace a #DIV/0! error is to wrap the division in IFERROR, such…
- How to Fix Double Spaces Between Words in Microsoft WordTo fix double spaces in Word, open Home > Replace, enter two spaces in Find what and one…
- Excel Not Evaluating Formula? Fix Common CausesIf Excel is not evaluating a formula, first select Formulas > Calculation Options > Automatic, then check that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.