Excel Hyperlink Not Working? Fix Links and Common Causes

If an Excel hyperlink is not working, first check whether Excel requires Ctrl+click, then verify the link’s destination and access permissions. In Microsoft 365 for Windows, hold Ctrl while clicking a link; if that does not help, right-click it, choose Edit Hyperlink, and inspect the address or file path.

What “not working” can mean

A hyperlink can fail in several different ways: clicking it does nothing, Excel opens the wrong page or file, a warning appears, or the destination opens but reports that it cannot be found. Identifying which behavior you see helps narrow the cause. A link to a website, a local file, a network folder, and a location inside the workbook each depends on different things.

Also distinguish a clickable hyperlink from an external workbook link. A hyperlink is an address a person follows, such as a website or another file. An external workbook link is a formula or connection that retrieves data from another workbook. The latter may show an update or security warning and is managed differently; repairing a clickable hyperlink will not necessarily repair a formula that references another file.

Try the quickest checks first

In desktop Excel for Windows, hyperlinks normally use Ctrl+click to follow. A single click may select the cell instead. Try holding Ctrl and clicking the linked text. You can change this behavior in File > Options > Advanced, under Editing options, by clearing Use Ctrl+Click to follow hyperlink. That changes how links are activated, not whether their destinations are valid.

If the link still fails, use these checks in order:

Right-click the linked cell and select Edit Hyperlink. Review the displayed address or file path before opening it.
Copy the address from the dialog and try it in a browser or File Explorer, if it is safe to do so. This helps tell whether Excel or the destination itself is the problem.
Check whether the target file, website, or shared folder still exists and whether your account can access it.
Ask a colleague with the same workbook and access rights to try the link. If it works for them but not you, investigate your account, browser, or device settings.

Do not open an unexpected link just to test it. A workbook can contain links to untrusted websites or files, so inspect the destination and consider who supplied the file.

Check the destination and permissions

A link can be perfectly valid as text yet point somewhere you cannot reach. Websites may have moved, expired, or require a sign-in. A OneDrive or SharePoint link can require permission from the file owner, and a link copied from a private account may not work for other people. If the destination is online, try signing in to the correct work or personal account and ask the owner to confirm that you have access.

For a file link, confirm that the named file has not been renamed, moved, or deleted. A link to a file on one person’s computer, such as a path under their user folder, will usually be useless to colleagues because that location does not exist on their computers. Network locations can also fail when a VPN is disconnected, a server is unavailable, or a mapped drive letter differs between users.

When sharing a workbook, prefer a stable SharePoint or OneDrive sharing link, with appropriate permissions, over a link to a temporary download or an individual computer’s local path. A link that works for its creator is not proof that other recipients can open the target.

Repair links to files and folders

Local file links are sensitive to where the workbook and target file are stored. Moving either one can make a previously working address obsolete. Relative paths may work when a linked file remains in the expected position relative to the workbook, while an absolute path names a particular drive or folder. The exact stored address can depend on how the link was created and where the workbook is saved.

To repair one, right-click the cell, choose Edit Hyperlink, and browse to the correct file or enter its current path in the address field. If the file is on a shared drive, use a location that all intended recipients can reach. A mapped drive such as one assigned a letter on your PC may not have the same letter on another PC; ask your administrator which shared path is supported rather than guessing.

If the workbook is being moved as a set with linked files, keep the folder structure intact and test the links from the new location. For a large set of links, first make a copy of the workbook, then inspect a few addresses to understand whether they share the same old folder or naming pattern. Bulk find-and-replace can alter unrelated text or formulas, so it is not a safe substitute for checking the actual hyperlink destinations.

Check Excel’s link and security behavior

Office and Windows may show a security warning before opening a link, especially when a workbook came from the internet or the destination is considered untrusted. A warning is not necessarily evidence that the hyperlink is broken. Read the destination and the warning carefully; only proceed if you trust the workbook and the target. If the file opens in Protected View, do not choose Enable Editing unless you trust its source and need to edit it.

Excel’s Trust Center settings are not a universal repair switch for clickable hyperlinks. In Windows desktop Excel, File > Options > Trust Center > Trust Center Settings includes controls related to protected documents and external content. Some external-content settings concern data connections or workbook links, not ordinary web links. Avoid lowering broad security protections simply because one address fails; ask your organization’s IT administrator before changing managed settings.

Some failures happen outside Excel. A browser may be missing, misconfigured, blocked by organizational policy, or unable to handle a particular address. A file may be blocked by Windows or inaccessible under your current account. If other links also fail in other applications, troubleshoot the browser, file permissions, or device policy rather than changing every hyperlink in the workbook.

Re-create a hyperlink when its address is wrong

In Excel for Microsoft 365 on Windows, select the cell or text, press Ctrl+K, enter or browse to the destination in the Insert Hyperlink dialog, and confirm. You can also use Insert > Link. To edit an existing link, right-click the cell and select Edit Hyperlink. To remove its link without deleting the cell contents, right-click and choose Remove Hyperlink.

For a destination inside the same workbook, use the Place in This Document option in the link dialog and choose the sheet and cell. This avoids typing a destination that could point to a different workbook or an outdated sheet name. If the cell contains a long URL as plain text, Excel may not have made it a hyperlink at all; select the text and use Insert > Link to create one explicitly.

On a Mac, the Insert Link command is available from the Insert menu, and Command+K is the common shortcut for opening the link dialog. Menus and prompts can vary somewhat by Excel release. Excel for the web uses the browser’s interaction model and may open a link with a normal click; desktop Ctrl+click instructions do not necessarily apply there.

When a HYPERLINK formula is involved

A cell may display link-like text because it uses Excel’s HYPERLINK function rather than a link inserted through the dialog. If the formula is present, inspect its first argument: that is the destination. A formula can display the intended label while still pointing to an old URL or file path. The formula below is an illustrative website link; in this example, the label Microsoft appears and clicking it directs to the stated site.

With no special cell layout required, enter this formula in a worksheet cell: =HYPERLINK("https://www.microsoft.com","Microsoft")

Check that the address is spelled correctly and enclosed in straight quotation marks. If a formula builds an address from other cells, inspect the resulting address as well as its component values; a blank cell, extra space, or changed folder name can produce a destination that no longer exists. Editing a formula is different from using Edit Hyperlink on a manually inserted link, so first check the formula bar to see which kind you have.

Excel desktop, web, and Mac differences

Excel for Windows desktop can follow links to websites and files available to Windows, subject to permissions and security controls. Excel for the web runs inside a browser, so local file paths and destinations that require a desktop application may behave differently or may not be reachable from the browser. Cloud links are generally more suitable for sharing through the web version, but the recipient still needs permission.

Excel for Mac also has hyperlink editing, but Windows-specific instructions such as File > Options do not apply to its menus. Keyboard shortcuts can differ: Command+K opens the link dialog on Mac, compared with Ctrl+K on Windows. If the same link works in one Excel version but not another, compare the destination type, account access, and whether the file or application is available on both devices before changing the workbook.

Prevent the same problem when sharing

Before distributing a workbook, test representative links from the saved copy in the location where recipients will access it. This catches links that rely on your original folder, login, or mapped drive. Keep link labels descriptive—for example, name the document or destination rather than using generic text such as “click here”—so readers can assess a link before opening it.

Use shared cloud links for collaborative files and confirm recipient permissions.
Avoid personal computer paths and temporary download links in workbooks sent to others.
After renaming or moving files, review links that point to the changed locations.
Keep a backup before making widespread edits, and test several repaired links before replacing the original workbook.

If a workbook came from someone else and contains many unexpected links, ask the sender what each link is for. A broken link may be a simple stale path, but a suspicious or unexplained destination is a reason to pause rather than bypass security warnings.

Frequently Asked Questions

Why do I have to hold Ctrl to open a hyperlink in Excel?
Excel for Windows commonly uses Ctrl+click so a normal click can select or edit a cell without following its link. You can change that option at File > Options > Advanced under Editing options, but the setting does not fix a bad address.

Why does my Excel hyperlink work for me but not a coworker?
The coworker may not have permission, may not be signed in to the required account, or may not have access to the same drive or local folder. Use a shared location and verify access with the recipient’s account.

How do I fix a hyperlink after moving a file?
Right-click the link, choose Edit Hyperlink, and browse to the file in its new location. If several related files moved, confirm the folder structure and test links from the workbook’s new saved location.

Why does Excel show a warning when I click a link?
Office or Windows may be warning that the destination is external or untrusted. Inspect the destination and proceed only if you trust it; do not disable general security protections just to suppress a warning.

Why does clicking a URL in a cell do nothing?
The URL may be plain text rather than a hyperlink, or Excel may be selecting the cell instead of following the link. Try Ctrl+click on Windows, or select the cell and use Insert > Link to create a hyperlink explicitly.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.