Excel Hyperlinks Stopped Working? Causes and Practical Fixes

When hyperlinks stop working in Excel, first check whether the link target is still valid and whether Excel is waiting for Ctrl+click: in Microsoft 365 for Windows, go to File > Options > Advanced and check Use Ctrl+Click to follow hyperlink. If the target is correct but Excel still does not open it, check the destination file, browser or app, and your access permissions before changing security settings.

What counts as a broken Excel hyperlink?

A hyperlink is a clickable address or reference stored in a worksheet. It can point to a web page, an email address, a file, or another place in the same workbook. A link may appear broken in different ways: clicking does nothing, it opens the wrong destination, Excel displays an error, or the destination opens but cannot be accessed. The right fix depends on which behavior you see.

It also helps to distinguish hyperlinks from external workbook links. A hyperlink is something a user clicks to navigate. An external workbook link is a formula or connection that retrieves data from another workbook, such as a formula referring to a cell in a separate file. Microsoft 365 for Windows lists many workbook references under Data > Workbook Links. Updating a source there can repair linked values, but it does not repair a clickable hyperlink in a cell.

A third case is text that only looks like a link. A blue, underlined web address is often automatically made clickable, but formatting alone does not prove that a valid hyperlink exists. Right-click the cell and look for an option such as Edit Hyperlink. If it is absent, the cell may just contain formatted text.

How Excel follows hyperlinks

Excel can store a hyperlink directly on a cell or shape, or display a link returned by the HYPERLINK function. A stored link has a destination independent of the visible cell text: a cell can say Company portal while pointing to a long web address. Editing the displayed text does not necessarily update that destination.

On Windows desktop Excel, the Use Ctrl+Click to follow hyperlink option determines whether you must hold Ctrl while clicking a link. When the option is enabled, a normal click selects the cell and Ctrl+click follows the link. When it is disabled, a normal click follows it. This is a frequent explanation when a user expects a single click to open a link, or when a click only selects the cell.

Excel hands many destinations to another program. A web address is generally opened by the default browser, an email link by the application assigned to email links, and a file path by Windows if the file can be found and opened. Excel can therefore be working properly while the browser, default application, network connection, or file permissions cause the apparent failure.

Quick checks before changing the link

Start with the simplest checks. Click the cell once and look at the formula bar and the status bar; depending on the link type and Excel version, these can help reveal whether the cell contains a formula or a destination. Then test the link using the required click method. Avoid repeatedly clicking a link if it launches an unexpected file or website.

Check the click setting. In Excel for Microsoft 365 on Windows, open File > Options > Advanced, find Editing options, and review Use Ctrl+Click to follow hyperlink. Test the link using the behavior shown by that setting.
Inspect the destination. Right-click the linked cell and choose Edit Hyperlink. Read the address or file path carefully. Look for a missing character, an outdated folder name, a misspelled domain, or an unintended space.
Test the destination outside Excel. For a web link, copy the address and try it in a browser. For a file link, check that the file exists at that location and that your account can open it.
Try a different link in the same workbook. If other links work, the problem is likely specific to that target. If none work, investigate Excel’s click setting, the default app, or a broader security or network restriction.
Check access and connectivity. A SharePoint, OneDrive, or company site link may require a signed-in account or permission. A working internet connection does not guarantee permission to open a protected destination.

These checks help separate a bad address from a problem following an otherwise valid address. That distinction matters: editing a correct link will not fix an account permission, and changing Windows settings will not repair a misspelled file path.

Repair or replace a hyperlink

If the address is wrong, right-click the cell and choose Edit Hyperlink. Replace the destination in the address field, keep or revise the display text as needed, and confirm the change. The dialog can show different fields depending on whether the target is a web page, an email address, or a file. Use an address that is reachable from the computer and account that will use the workbook.

To create a link from scratch, select the cell or object and press Ctrl+K on Windows, or use Insert > Link. Enter or browse to the destination and add readable display text when appropriate. For a web destination, include the full address, such as https://example.com/products, rather than relying on a partial name that Excel may interpret differently. For an internal destination, choose a place in the current document if the link dialog offers that option.

When many links are broken because a folder or website changed, identify the pattern before editing them one by one. For example, a set of links may all point to an old shared-drive folder. If the workbook contains ordinary hyperlinks, repairing them is different from changing an external workbook source; confirm which kind you have before using a bulk replacement or workbook-link command. Save a copy before making wide-ranging edits, especially in a workbook used by other people.

Why links to files and shared folders break

File hyperlinks often depend on a location that is not stable for every user. A link to a file on a local drive, such as a folder under one person’s user profile, may work only on that person’s computer. A mapped drive letter can also differ between computers. Moving or renaming the target file or one of its parent folders makes a stored path stale.

Links to shared folders can fail when a user is disconnected from the company network, has not connected to a VPN, or lacks permission. A path that uses a server name may be more consistent across a workplace than a drive letter, but it still depends on network access and authorization. For files shared through OneDrive or SharePoint, a cloud sharing link is often more suitable than a path to a locally synchronized folder, although the recipient still needs the right account and permissions.

Relative paths can be useful when a workbook and its linked files are kept together in a predictable folder structure, but they are not a guarantee that every link will survive a move. If a workbook is emailed without its companion files, or only one part of a folder structure is copied, the destination may no longer resolve. For a shared workbook, test links from the same location and account conditions that recipients will use.

Browser, app, and security issues

If a web hyperlink reaches a browser but the browser shows an error, the link may be valid while the site is unavailable, the address has redirected, or access requires a sign-in. If clicking appears to do nothing, check that Windows has a default browser assigned. Open Windows Settings > Apps > Default apps and review the browser and web protocols. For email links, check which app is assigned to handle email links.

Excel and Windows may display warnings when a link points to an unfamiliar or potentially unsafe destination. Treat an unexpected warning as a reason to verify the sender and target, not as an obstacle to bypass. Do not disable security protections just to make a link open. If a workbook came from an untrusted source, confirm that the file and destination are legitimate with the sender or your organization’s support team.

Links to local files have additional limits in browser-based environments. A browser cannot freely access files on a computer merely because a workbook contains a path to them. Excel for the web may handle links differently from desktop Excel, and access to a cloud file depends on its URL and permissions. If a link works on one person’s desktop but not for colleagues using Excel for the web, replace a machine-specific path with an appropriately shared cloud destination where possible.

Hyperlink formulas and imported data

The HYPERLINK function builds a clickable link from a destination and optional display text. With a URL in A2 and the words Product page in B2, enter this formula in C2: =HYPERLINK(A2,B2). If A2 contains https://example.com/product and B2 contains Product page, C2 displays Product page and links to that URL. The function does not make an invalid address valid; it simply uses the destination supplied to it.

When a formula-generated link fails, inspect the source cell as well as the formula. A trailing space, a missing protocol, or a URL assembled from an outdated value can produce an incorrect target even when the formula itself is valid. Click the formula cell and use Edit Hyperlink if available, or examine its formula and referenced cells. If the formula displays an error instead of link text, resolve that formula error first.

Data copied from websites, exports, or another spreadsheet can contain plain text, hidden spaces, or addresses that were not preserved as links. Pasting values may remove a hyperlink while leaving its visible label. Conversely, a cell can retain a hyperlink even after its displayed text has been replaced. When importing a list, test a few representative rows and verify the actual destinations rather than assuming that blue formatting means the links are correct.

Excel for Mac and Excel for the web

The Windows instructions above apply to Microsoft 365 desktop Excel on Windows. In Excel for Mac, the click modifier and settings can differ. Excel for Mac commonly uses Command-click to follow a hyperlink when that behavior is enabled; review Excel > Settings > Edit for the hyperlink-click preference. The Mac keyboard shortcut for inserting a link is Command+K rather than Ctrl+K.

Excel for the web runs in a browser and does not expose the same File > Options dialog as Windows desktop Excel. Link behavior can also be affected by the browser, organizational sign-in, and whether a destination is a local file or a shared online resource. If the link works in desktop Excel but not in the browser, check the destination type and permissions, then try the workbook in the intended environment before changing the link for everyone.

Frequently Asked Questions

Why do I have to press Ctrl before clicking a link in Excel?

On Windows desktop Excel, Use Ctrl+Click to follow hyperlink is enabled. Go to File > Options > Advanced and review that setting. With it enabled, Ctrl+click follows the link; with it disabled, a normal click follows it.

Why does my Excel hyperlink open the wrong website or file?

The stored destination may be outdated or different from the displayed text. Right-click the cell, choose Edit Hyperlink, and inspect the actual address. If the link is generated by a formula, check the referenced cells for old paths, spaces, or incorrect URL parts.

Why do Excel hyperlinks work for me but not for someone else?

The link may point to a file on your computer, a mapped drive, or a protected cloud location. The other person may not have the same path, network connection, account, or permissions. Share the target in a location both users can access and use a suitable shared link.

Why does a hyperlink look clickable but do nothing?

It may be plain text with hyperlink-style formatting, or Excel may require Ctrl+click. Right-click the cell to see whether Edit Hyperlink is available, and check the click setting. If the text is only formatted, create a link with Insert > Link.

Are broken workbook links the same as broken hyperlinks?

No. A hyperlink opens a destination when clicked. An external workbook link supplies data to formulas or connections. Use the appropriate repair method: edit the hyperlink destination for navigation, or review Data > Workbook Links for supported external workbook references.

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.