Excel Hyperlink Not Opening? Fix Common Link Problems

If an Excel hyperlink is not opening, first check whether Excel requires Ctrl+click, then verify the link’s destination and your default app or browser. In Excel for Microsoft 365 on Windows, a broken or inaccessible destination, a missing file, or a security restriction can also prevent a link from working.

How Excel opens hyperlinks

A hyperlink in a worksheet can point to a website, an email address, another place in the workbook, or a file on a computer or network. Excel passes an external link to Windows, which then uses the default browser or the app associated with that file type. A link can therefore be correct in the worksheet but still fail because the destination has moved, the relevant app is unavailable, or the system cannot reach it.

Internal links behave differently: they navigate to a location in the current workbook. A link may also be inserted directly into a cell or created by a formula. Identifying which kind of link you have helps narrow down the problem before changing settings.

Check whether Excel requires Ctrl+click

In desktop Excel for Windows, the default setting commonly requires you to hold Ctrl while clicking a hyperlink. A regular click selects the cell instead, which can look like the link is unresponsive. Hovering over the cell may show a link destination or prompt, but the reliable test is to hold Ctrl and click the linked cell.

To check the setting, open File > Options > Advanced. Under Editing options, look for Use Ctrl+Click to follow hyperlink. If it is selected, use Ctrl+click. If you clear it, a normal click follows links instead; that also makes selecting a linked cell by clicking less convenient. Excel for Mac uses Command-click in versions that require a modifier key, and the setting is in Excel’s editing preferences. In Excel for the web, links are generally followed with a regular click, subject to browser behavior.

Inspect the link destination

A hyperlink can display friendly text such as Open report while pointing to an entirely different address. Right-click the cell and choose Edit Hyperlink to inspect its destination. You can also select the cell and look at the link information shown by Excel, or use the formula bar if the cell contains a HYPERLINK formula. Do not assume the visible label tells you where the link goes.

Check for common destination errors: a missing letter in a web address, an outdated page, an extra space, or a file path that no longer exists. For example, a link to C:\Reports\April.xlsx will not work on a computer that does not have that file at that location. A network drive letter may also differ between users. If the destination is a web page, try copying the address and opening it in a browser. If that fails too, the issue is likely the address, access, or network rather than Excel’s click behavior.

For a website, make sure the address includes the correct protocol, such as https://, and that the site is reachable. For a file, confirm that you can open the file directly in File Explorer and that you have permission to access its folder. If the link is stale, edit it with the current destination using Insert > Link or the right-click menu.

Check your browser and associated apps

When a web link appears to do nothing, Windows may not have a working default browser association, or the selected browser may be blocked from opening. Check Settings > Apps > Default apps in Windows and confirm a browser is assigned to web links. Then open the browser separately and check whether it can load a normal website. A work computer may also use managed browser settings or network rules that restrict particular addresses.

For links to documents, confirm that an app capable of opening the file type is installed. A link to a PDF, for instance, needs a PDF viewer or a browser that can display PDFs. If Excel asks which app to use, choose an appropriate one and, if desired, set it as the default for that file type. If the target opens in another browser or app than expected, that is usually controlled by Windows associations rather than by the hyperlink text in Excel.

Resolve file, network, and cloud-link problems

File links are especially sensitive to location. A link to a file on one person’s desktop, a removable drive, or a mapped network drive may not be meaningful on another computer. Moving or renaming the target file can break the link even though the workbook itself has not changed. Store shared files in a location all intended users can access, and use a link designed for that shared location rather than a path tied to one person’s device.

For OneDrive or SharePoint files, confirm that the file still exists, that you are signed in to the correct account, and that you have permission. A link may open a sign-in page or an access-denied message instead of the document; that is different from Excel failing to activate the hyperlink. If another person cannot open it, ask the owner to verify sharing permissions and send a current sharing link. Do not assume that copying a local synchronized folder path will work for colleagues who have a different sync location.

Network availability matters too. A link to a company server may work only while connected to the organization’s network or VPN. Try opening the target through its normal route and check with your IT administrator if the server or permission is unavailable. Avoid changing a link to a public location just to get around an access restriction, especially if the file contains confidential information.

Understand security prompts and blocked links

Excel, Windows, a browser, or an organization’s security policy may warn about an external link or restrict access to a destination. Read the prompt carefully: it may be asking you to confirm that you trust the source, sign in, or allow an app to open. A link from an unexpected workbook can lead to a deceptive site or an unsafe download, so verify the sender and destination before continuing.

If a warning appears every time, do not disable security protections indiscriminately. In a managed work environment, a policy may intentionally block certain websites, file types, or external locations. Ask your IT administrator to review a legitimate business link. If Excel itself shows a Protected View or security banner, follow your organization’s procedure for confirming the workbook is trustworthy; do not treat the warning as proof that the link is broken.

When the cell uses a HYPERLINK formula

A formula-created link can fail because its link location is wrong, even when the friendly text looks normal. For example, with a formula entered in a worksheet cell, this creates a link labeled Open site:

=HYPERLINK("https://example.com","Open site")

Check the formula bar for spelling, quotation marks, and any cell references used to build the destination. If the formula combines text from other cells, inspect those source cells for missing parts or unwanted spaces. A formula can calculate a URL correctly but still point to a page that has moved or requires access. Clicking it follows the same general activation rules as other hyperlinks, including Ctrl+click when that option is enabled.

For a link that should open a local file, confirm that the formula’s path matches the file’s actual location and that the current user can access it. If a formula returns an error or displays unexpected text, first correct the formula or its inputs; changing browser settings will not repair a malformed destination. Also distinguish a calculated hyperlink from plain text that merely looks like a URL: text is not necessarily a clickable link until Excel recognizes or inserts it as one.

A quick troubleshooting sequence

Use these checks in order to separate an Excel setting from a destination or access problem:

Hold Ctrl and click the cell in desktop Excel for Windows. On Mac, try Command-click if required by your version.
Right-click and choose Edit Hyperlink to confirm the actual address or file path.
Test the destination outside the workbook: paste a website address into a browser, or open the file through File Explorer.
For a web link, check the default browser and whether the address is reachable. For a file, check its location, app association, and permissions.
For shared cloud links, check sign-in status and sharing access. For company resources, check network or VPN access and ask IT about policy blocks.
If the link is wrong, update it. If only one workbook has the issue, compare its links with a working workbook before changing system-wide settings.

This sequence is useful because it avoids treating every failure as an Excel bug. If the same URL fails when pasted into the browser, focus on the URL, service, or access. If it works outside Excel but not when clicked, focus on Excel’s modifier-key setting, the workbook’s link type, or a security prompt.

Frequently Asked Questions

Why does clicking an Excel link select the cell instead of opening it?
Excel for Windows may be set to require Ctrl+click. Hold Ctrl while clicking, or review File > Options > Advanced and the hyperlink setting under Editing options.

How do I change a hyperlink in Excel?
Right-click the linked cell and choose Edit Hyperlink, then replace the destination and confirm. You can also select the cell and use Insert > Link to review or edit its link.

Why does an Excel file link work for me but not a coworker?
The link may point to a local folder, a drive letter, or a cloud file your coworker cannot access. Use a shared location and verify that the coworker has permission and is signed in to the correct account.

Why does an Excel hyperlink open the wrong browser?
Excel usually hands web links to the system’s default browser. Change the default browser in Windows settings, or ask your administrator whether managed device settings control the choice.

Can I make Excel open links with one click?
In Windows desktop Excel, clear Use Ctrl+Click to follow hyperlink under File > Options > Advanced, in Editing options. This changes how clicks behave in that Excel setup, so selecting linked cells may become less convenient.

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.