Excel Spreadsheet Hyperlinks Not Working? Fixes to Try

If Excel spreadsheet hyperlinks are not working, first check that the link’s address is correct and that the destination still exists; then test whether the problem affects one link, the workbook, or the computer. In Excel for Microsoft 365 on Windows, right-click a link and choose Edit Link to inspect or replace its address, or press Ctrl+K to create a new link.

Identify What Is Failing

“Not working” can describe several different problems: a link looks like ordinary text, clicking it does nothing, Excel displays an error, or it opens the wrong destination. The right fix depends on which symptom you see. A broken link to a moved file needs a different remedy from a web address that was never converted into a hyperlink.

Try a few links in the same workbook and, if possible, open the workbook on another computer. If only one link fails, inspect its address and destination. If all links fail in one workbook, consider workbook-specific issues such as Protected View or outdated file paths. If links fail in multiple workbooks, check Excel, Windows, and your browser or file-opening settings.

Plain text: The address may not have been converted into a hyperlink.
An error such as “Cannot open the specified file”: The destination may have moved, been renamed, or become inaccessible.
A web link opens the wrong app or no app: The default browser or web-link handling may be the issue.
A warning appears: Excel or Windows may be asking you to confirm an external destination.

Check the Address and Destination

Right-click the affected cell and choose Edit Link (the wording can vary slightly between Excel builds). Review the address in the dialog. Look for missing characters, extra spaces, a misspelled web address, or a file path that points to an old folder. For a web destination, check that the address begins with the intended protocol, usually https://. A link copied from another app can include punctuation or tracking text that changes where it leads.

Then test the destination outside Excel. Paste a web address into a browser, or use File Explorer to navigate to a linked file. If the destination itself cannot be opened, repairing the hyperlink will not restore the missing page or file. Ask the owner for a current address, restore the file from an appropriate location, or update the link to the file’s new location.

For a link to a local file, confirm that the file exists and that you have permission to open it. A path such as C:\Reports\April.xlsx works only for a user whose computer has that file at that location. It is not a portable link for colleagues whose folder structure or drive letters differ. A shared network location or an organization-approved cloud link is usually more suitable when several people need access.

Create or Repair a Hyperlink

To add or replace a link in Excel for Microsoft 365 on Windows, select the cell, press Ctrl+K, enter or browse to the destination in the Insert Hyperlink dialog, and confirm. You can also use Insert > Link on the ribbon. To change an existing link, right-click the cell and choose Edit Link. To remove the hyperlink while keeping the cell’s displayed text, right-click and choose Remove Hyperlink.

On a Mac, select the cell and use Command+K or choose Insert > Link; dialog labels and available destination options can differ from Windows. In Excel for the web, use Insert > Link or the link option in the cell’s context menu. Some desktop features and file destinations behave differently in the browser, so a link to a local computer file may not be useful to other people opening the workbook online.

For a set of web addresses, a formula can display a clickable link. With the URL in A2, enter =HYPERLINK(A2,A2) in another cell. If A2 contains https://www.example.com/report, the result displays that address as a clickable hyperlink. The formula cannot make a dead page available; it only creates a link using the address supplied in A2. If the source cells contain plain text with extra spaces or incomplete addresses, correct that data first.

When an Address Is Plain Text

Excel can automatically turn some typed web addresses into hyperlinks, but automatic conversion may be disabled or may not happen when text is pasted, imported, or entered in a format Excel does not recognize. Typing a URL into a cell and pressing Enter is a useful test. If it remains plain text, select the cell and add the link with Ctrl+K rather than assuming the text is clickable.

To check the automatic-formatting setting in Excel for Microsoft 365 on Windows, open File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and look for Internet and network paths with hyperlinks. If the setting is off, Excel will not automatically convert qualifying addresses as you type. Changing this option affects automatic formatting; it does not repair existing links or validate their destinations.

Pasted data can also contain invisible leading or trailing spaces. Inspect the cell’s contents in the formula bar, or edit the address through the hyperlink dialog. Be cautious when cleaning imported data: removing spaces indiscriminately can alter a legitimate address or other cell contents. For a small number of cells, editing the link directly is generally easier to verify.

Fix Links to Moved or Shared Files

Links to files are sensitive to changes in location and access. If a workbook and its linked file were moved together, some relative links may still resolve, while an absolute path that names the old folder may not. Moving a workbook to another computer, changing a mapped drive, renaming a folder, or reorganizing a shared site can all leave a link pointing to a location the current user cannot reach.

Open the link’s edit dialog and update the address to the current location. For a shared workbook, consider whether every intended reader has access to the destination. A link that works for its creator may fail for a coworker because the coworker lacks permission, is signed into a different account, or cannot access the same network. Share the destination with the appropriate people using your organization’s normal access controls; changing the hyperlink alone does not grant permission.

Cloud links can also depend on how the destination was shared. A copied link may require sign-in, may be limited to specific people, or may no longer be valid after sharing settings change. Test it while signed in as an authorized user. If you need a workbook to travel between computers, avoid relying on paths tied to one person’s desktop or downloads folder.

Understand Warnings and Security Blocks

Hyperlinks can lead outside the workbook, so Excel and Windows may display a security warning before opening a file or website. A warning is not proof that the link is broken; it is a prompt to consider whether the destination is trustworthy. Check the full address and confirm that the workbook and destination are expected before proceeding. Do not disable security protections just to make an unfamiliar link open.

Workbooks downloaded from the internet or received by email may open in Protected View. If Excel shows a Protected View banner, use Enable Editing only when you trust the file and have checked its source. This changes whether you can edit the workbook; it does not establish that every hyperlink inside it is safe. Links can lead to phishing pages or unexpected downloads, so assess the destination independently.

If clicking a valid web link does nothing or launches an unexpected browser, check whether Windows has a default browser selected and whether that browser opens normally. The precise Windows settings path can vary by Windows release, but look for Settings > Apps > Default apps and verify the default for web links. For a local file, confirm that Windows has an app associated with that file type. Excel may pass the destination to the operating system rather than open every kind of file itself.

Distinguish Hyperlinks from Workbook Links

A hyperlink is a clickable route to a web page, file, email address, or location in a workbook. It is different from an external workbook link, which brings data or formulas from another workbook into the current one. A cell containing a formula that refers to another file can show an update or source-workbook prompt; that does not necessarily mean a clickable hyperlink is broken.

This distinction matters when troubleshooting. If clicking a cell should open a page or file, edit the hyperlink. If a formula displays outdated values from another workbook, inspect the formula’s source reference and whether the source workbook is available. Updating external data connections or workbook formulas is not the same as repairing a link created with Insert > Link.

Links to locations inside the same workbook also behave differently from external destinations. A sheet may have been renamed or a target cell removed, leaving an internal link pointing somewhere that no longer exists. Update the link to the current sheet or location. This is often a clearer fix than recreating the entire workbook or changing Windows settings.

A Practical Troubleshooting Order

Work from the simplest checks toward broader changes. This keeps you from changing security or system settings when the actual problem is one mistyped address.

Click the link and note the exact result or error message.
Right-click the cell, choose Edit Link, and inspect the destination for spelling, spaces, and outdated paths.
Test the destination in a browser or File Explorer, and confirm that your account has permission to open it.
Try another link and another workbook to see whether the problem is limited to one cell, one file, or the whole computer.
If a valid web link will not launch, check the default browser. If the workbook is in Protected View, proceed only if you trust its source.
Save a copy before making widespread edits, especially when many links or shared files are involved.

For a workbook with many broken links, make a small inventory of the affected cells, their current addresses, and the correct destinations before editing them in bulk. That record makes it easier to review changes and catch accidental replacements. Avoid downloading a third-party “link fixer” or running a macro from an unknown source simply because several links need attention.

Frequently Asked Questions

Why does Excel say it cannot open the specified file?
The link may point to a file that was moved, renamed, deleted, or stored somewhere you cannot access. Edit the link, verify the current path in File Explorer, and check that you have permission to open the destination.

Why is my URL in Excel not clickable?
Excel may not have converted the text into a hyperlink, especially if it was pasted or automatic formatting is disabled. Select the cell and use Ctrl+K on Windows (Command+K on Mac) to add a link.

Can I make a hyperlink work for everyone who opens the workbook?
Only if the destination is available to those readers and their accounts have permission. A link to a file on your personal computer will not automatically give coworkers access to that file.

Why does Excel show a warning when I click a hyperlink?
Excel or Windows may be warning that a link opens an external website or file. Check the destination and proceed only if you trust it; do not treat the warning itself as evidence that the link is broken.

Does updating workbook links fix hyperlinks?
No. External workbook links supply data to formulas, while hyperlinks open destinations when clicked. Identify which kind of link is involved before changing its settings or address.

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.