Excel Hyperlink Not Working? How to Fix It

If an Excel hyperlink is not working, first check how Excel expects you to open it: in Microsoft 365 for Windows, hold Ctrl and click the linked cell or object. If that does not work, right-click the link and choose Edit Hyperlink to verify its destination; a wrong address, moved file, browser setting, or security prompt can also stop it opening.

How Excel hyperlinks work

A hyperlink is an address attached to a cell, selected text, picture, shape, or formula result. It can point to a webpage, an email address, a file, or a location in the current workbook. The words displayed in a cell are not necessarily the address: a cell labelled “Open report” might lead to an old folder, so inspect the actual destination instead of relying on its label.

Excel handles the link, but it usually hands web pages and files off to Windows or another app. That means a link can be valid in the workbook yet fail because the browser, file association, network connection, or access permission is unavailable. Excel for the web also runs in a browser, so it cannot always open a local file on your computer in the same way as desktop Excel.

There are two common ways to create a link. You can use Insert > Link, or use the HYPERLINK function in a cell. With a website address in A2, for example, a formula in B2 can display a friendly label and open that site:

With the URL in A2, enter this in B2: =HYPERLINK(A2,"Open the website"). If A2 contains https://www.example.com, the link label appears in B2 and opens that address when followed.

Knowing whether the link is a regular hyperlink or a formula link helps narrow down the cause. A formula can display an error or point to a bad address; a manually inserted link can have a stale destination even while its visible text looks correct.

Check the click behavior first

Excel for Windows commonly requires Ctrl+click to follow a hyperlink. A normal click selects the cell, which can look like the link is dead. This is a setting, not a sign that the link is broken.

Try Ctrl+click on the linked cell, shape, or picture.
To change the behavior, go to File > Options > Advanced. Under Editing options, clear Use Ctrl+Click to follow hyperlink if you want a normal click to open links.
If you are using Excel for Mac, try Command+click. Control-click generally opens a context menu rather than following the link.
If the cell is being edited, finish or cancel the edit before trying to follow the link.

Be deliberate when changing the click setting: turning off Ctrl+click makes it easier to open links accidentally while selecting cells. On a touch screen or in Excel for the web, interaction can differ; use the link’s context menu or click the displayed link as the interface allows.

Inspect and repair the destination

Right-click the linked cell and choose Edit Hyperlink. In the dialog, check the address or file path and correct it if necessary. If you do not see that choice, the cell may contain a HYPERLINK formula; select the cell and inspect the formula bar. You can also use Ctrl+K to open the link dialog for a selected cell. On a Mac, use Command+K where supported.

Look for common address mistakes: a missing https://, a spelling error in a domain, an extra space, an outdated folder name, or a file extension that no longer matches the file. For websites, copy the intended address from a trusted source and compare it with the stored destination. A display label such as “Company portal” does not confirm that the link goes to the genuine company site.

For a file link, confirm the file still exists at that location and that you have permission to open it. A link to C:\Reports\Q4.xlsx points to a particular path on a computer; it will not automatically find a copy stored under a different user profile or drive letter. Links to shared network folders can fail when you are off the network or disconnected from a VPN. If the file was moved, edit the link to its current location.

For a link to another worksheet in the same workbook, check that the sheet name and cell reference are still correct. With a sheet named Monthly Summary, this formula links to cell A1 on that sheet:

With no source data required, enter this formula in the cell where you want the link: =HYPERLINK("#'Monthly Summary'!A1","Go to summary"). It displays “Go to summary” and navigates to A1 on the Monthly Summary sheet.

When the link is a HYPERLINK formula

Select the formula cell and inspect the formula bar. Check that the address is enclosed in straight quotation marks when typed directly, that parentheses are balanced, and that each comma separates the intended arguments. Excel’s regional settings can affect the separator used in formulas, but the examples here use commas. If the formula displays an error, fix the formula or the address it references before troubleshooting browser settings.

For a basic website link, the destination and friendly label can be written directly in the formula:

With the formula entered in any cell, no separate source range is needed: =HYPERLINK("https://www.example.com","Open the website"). It displays “Open the website” and links to the example address.

If a formula builds its address from other cells, check those inputs too. A blank cell, a misspelled domain, or a path assembled with the wrong separator can produce an unusable destination even though the formula itself calculates. Click the link only after confirming the destination is one you trust.

Understand browser, file, and security issues

When a web link appears to do nothing, test the address by copying it from Edit Hyperlink and pasting it into a browser. If it fails there as well, the problem is likely the address, the website, the network, or the browser rather than Excel. If it opens in the browser but not from Excel, check that Windows has a default browser selected in Settings > Apps > Default apps, and try closing and reopening Excel after changing that default.

A file link may open in the wrong application or fail because Windows has no suitable default app for that file type. Check the file extension and whether the target file opens directly from File Explorer. For OneDrive or SharePoint files, confirm that you are signed in to the account with access. A cloud link can also be more portable than a link to a local drive, but people who receive it still need permission.

Excel or Windows may show a security warning before opening a link, especially when the destination is an external file or appears potentially unsafe. Read the address and warning carefully. Only proceed if you recognize and trust the source. Do not disable security warnings or change registry settings just to make an unfamiliar link open; ask the workbook’s sender or your organization’s IT support if the link is unexpected.

Why newly typed URLs may not become links

If you type a web address into a cell and it stays as plain text, Excel’s AutoFormat setting may be off. On Windows, go to File > Options > Proofing > AutoCorrect Options, open the AutoFormat As You Type tab, and check Internet and network paths with hyperlinks. This controls automatic conversion as you type; it does not repair hyperlinks that already exist or guarantee that every pasted address is converted.

You can still add a link manually: select a cell, press Ctrl+K, enter the destination in the address field, and confirm. Alternatively, use Insert > Link. On Mac, menu wording and the settings location can vary by Excel release; use Insert > Link or Command+K to add a link, and check Excel’s AutoCorrect or editing preferences if you want typed addresses converted automatically.

Autoformatting is convenient but not a safety check. Excel may turn a typed address into a clickable link without verifying that the site is safe or that the address is correct. Review the destination before sharing a workbook.

Excel desktop versus Excel for the web

In desktop Excel for Windows, hyperlinks can open web pages and files through the applications configured on that computer. Excel for the web opens in a browser and is designed to work with online content, such as websites and files stored in OneDrive or SharePoint. A path to a local drive, such as C:\Reports\Q4.xlsx, may not be usable from the browser because the workbook is not running as a desktop app with the same access to the computer’s file system.

If a link works in desktop Excel but not in the web version, check whether it points to a local file, a network share, or a location requiring desktop access. For a workbook shared with other people, consider using an approved SharePoint or OneDrive link and make sure recipients have permission. If a link works in the browser but not the desktop app, check the desktop app’s click behavior, default browser, and file associations.

A quick troubleshooting sequence

Work through these checks in order so you can identify whether the problem is the click, the link, or the environment:

Try Ctrl+click in Windows or Command+click on Mac to rule out the selection-versus-follow behavior.
Right-click and inspect Edit Hyperlink, or examine the formula bar if the cell uses HYPERLINK.
Test the destination outside Excel: open a web address in a browser or a file path in File Explorer.
Confirm the file has not moved and that your account, network, or VPN has access.
Check the Windows default browser or the app associated with the file type if the destination is valid but opens incorrectly.
In Excel for the web, replace an inaccessible local path with an appropriate online link, if sharing and permissions allow.

If only one link fails, focus on that link’s destination. If every link fails in one workbook, check the workbook’s formulas and the application or security settings. If links fail across all workbooks, investigate Excel’s click setting, Windows defaults, network access, and any organization-managed security policy.

Frequently Asked Questions

Why do I have to press Ctrl to open a hyperlink in Excel?
Excel for Windows uses Ctrl+click by default so a regular click can select the cell. Change the behavior at File > Options > Advanced by clearing Use Ctrl+Click to follow hyperlink. On Mac, try Command+click.

Why does my Excel hyperlink open the wrong website?
The visible cell text may differ from the saved address. Right-click the link and choose Edit Hyperlink, or inspect the HYPERLINK formula, then compare its destination with the correct URL. Replace it only with an address you trust.

Why will an Excel link to a file not open?
The file may have moved, the path may refer to another computer, or you may lack access to the drive or shared folder. Test the path outside Excel and confirm that the file exists and your account has permission.

Why is a URL in Excel not clickable?
Excel may not be set to autoformat typed web addresses. Enable Internet and network paths with hyperlinks under File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type, or add the link manually with Ctrl+K.

Can Excel for the web open a link to a file on my computer?
Not reliably in the same way as desktop Excel. A browser-based workbook may not be able to access a local file path. Use desktop Excel for local files, or use an approved OneDrive or SharePoint link with the right sharing permissions.

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.