Hyperlink Function Not Working in Excel? Fix It

If the HYPERLINK function is not working in Excel, check the formula syntax and the link address first; then confirm Excel is calculating formulas and that you are following the link rather than just selecting its cell. In Microsoft 365 for Windows, a basic working formula is =HYPERLINK("https://example.com","Open page").

What the HYPERLINK function does

HYPERLINK creates a clickable link in a worksheet. Its first argument, link_location, identifies a webpage, file, folder, or place in a workbook. Its optional second argument, friendly_name, is the text Excel displays in the cell. If you leave out the friendly name, Excel displays the link location itself. The function does not download or verify a destination; it gives Excel an address to open when the link is followed.

A result that displays words such as “Open page” may be working correctly even if the full web address is not visible. The visible label is not proof that the destination is reachable, however. A link may display normally and still fail when clicked because the address is misspelled, the file has moved, or access is restricted.

HYPERLINK is different from adding a link with the Insert Link command. A formula-created link can draw its address and label from cells, which is useful for lists and reports that change. An inserted link is attached to selected text or a cell as a link object, so it is convenient for a small number of fixed destinations.

Check the formula and its cell references

First select the cell and look at the formula bar. Confirm that the formula starts with an equals sign, uses HYPERLINK spelled correctly, and has parentheses around its arguments. Text values need straight quotation marks inside a formula. A missing quote, extra parenthesis, or reference to an empty cell can make the result differ from what you expect.

For a formula that uses cells, make sure those cells contain the intended address and display label. With web addresses in A2:A20 and link labels in B2:B20, enter this in C2 and fill it down:

=HYPERLINK(A2,B2)

For example, if A2 contains https://example.com and B2 contains Example site, C2 displays “Example site.” Clicking it should open the address in A2, subject to your browser, network, and security settings. If A2 is blank, contains an incomplete address, or has an unintended space, the displayed label can still look fine while the link destination is wrong.

Excel installations using some regional settings may expect semicolons between function arguments rather than commas. If Excel rejects an otherwise correct formula with a formula-entry error, check the list separator used by your Windows regional settings. The examples here use commas, as in the standard English-language syntax.

Make sure the formula is being calculated

If the cell shows the formula itself instead of a link label, Excel may be treating the entry as text. Select the cell, set its number format to General from Home > Number Format, and re-enter the formula. One quick way is to select the cell, press F2, and then press Enter. Also check that the entry does not begin with an apostrophe, which tells Excel to store it as text.

If many cells show formulas rather than results, the worksheet may have Show Formulas enabled. Press Ctrl+` on Windows to toggle that view; the backtick key is usually near the upper-left corner of the keyboard. On Mac, use Control+` where that shortcut is available, or switch off Show Formulas on the Formulas tab. This setting changes what the sheet displays; it does not remove the formulas.

For a formula that displays an old result or does not update after its source address changes, check calculation mode. In Excel for Windows, use Formulas > Calculation Options > Automatic. If calculation is set to Manual, press F9 to recalculate. A formula that has not recalculated can retain a stale display, although recalculation will not repair an incorrect destination.

Follow the link instead of selecting the cell

On Excel for Windows, the default behavior is commonly to require Ctrl+click to follow a hyperlink. A regular click selects the cell so that you can edit or copy it. Hold Ctrl while clicking the linked cell. If you prefer a normal click to follow links, go to File > Options > Advanced, find Editing options, and clear Use Ctrl+Click to follow hyperlink. Changing this option also changes how you interact with links while editing a worksheet.

On a Mac, try Command-click if clicking the cell only selects it; the exact interaction can depend on the Excel version and system. In Excel for the web, select or click the link according to the prompt shown in the browser. A link may open in a new tab, and browser pop-up or navigation controls can affect what happens next.

To test whether the cell contains a hyperlink at all, select it and inspect the formula bar. A formula beginning with =HYPERLINK( is formula-generated. If there is no such formula, the cell may contain a plain address rather than a clickable link, or it may have been inserted as ordinary text. In that case, use Insert > Link, or press Ctrl+K on Windows. On Mac, the equivalent shortcut is Command+K.

Check the destination address and file path

Web links should include a valid address, typically beginning with https:// or http://. A bare phrase such as example.com may not be interpreted as the web address you intended. Copy the address into a browser to check for a typo, an expired page, a sign-in requirement, or a network restriction. The fact that a link opens a browser does not guarantee that the website itself is available.

For a local file, verify that the file still exists at the path in the formula and that your account can access it. With a report stored at a fixed Windows location, for example, the formula can be:

=HYPERLINK("C:\Reports\April.xlsx","Open April report")

This example assumes the workbook is on Windows and the file really is at C:\Reports\April.xlsx. A coworker may not have the same folder, drive letter, or permissions. Moving a workbook or its linked file can also break a path, especially when the link points to a specific location rather than a shared location everyone can reach. For shared workbooks, use a destination accessible to the intended readers, such as an appropriate SharePoint or OneDrive link, and confirm they have permission.

For an internal link, the target sheet must exist, and the sheet name and cell reference must be valid. With a sheet named Sheet2, a link to cell A1 can be made with:

=HYPERLINK("#Sheet2!A1","Go to Sheet2")

This formula assumes the link is in the same workbook and that Sheet2 exists. If a sheet name contains spaces or punctuation, the reference needs the sheet name in single quotation marks within the address, such as #'Quarter Results'!A1. If the name is later changed, review the link target rather than assuming the displayed label will update it.

Understand errors, security prompts, and access limits

If Excel returns an error such as #VALUE!, inspect the link location first. It must evaluate to a usable address or location. Check for extra spaces, a missing path, a deleted destination, or a formula that refers to a cell containing an error. A valid-looking friendly name does not make an invalid first argument valid.

If clicking the link produces a warning or security prompt, read it before proceeding. Office and organizational security policies may warn about links to external websites or files. Do not bypass a warning just to make a link work: confirm that you recognize the source and expect the destination. An administrator may impose policies that individual users cannot change.

A link to a file can fail even when its syntax is correct if the file is on an unavailable network drive, requires a VPN, or is protected by permissions. Excel for the web also runs in a browser environment, so a local Windows path that works on a desktop may not be reachable from the browser. Try the link on the same device and account that the intended reader will use. Ask the file owner to confirm access if the destination is shared.

When to use HYPERLINK or Insert Link

Use HYPERLINK when link addresses or labels come from worksheet data, or when you need to create many links consistently. For example, a contact list can use one column for web addresses and another for readable labels, with a formula in a third column. If you sort or update the source data, the formula can refer to the corresponding row. Check relative references before copying formulas, and use absolute references when a formula needs to keep pointing to one fixed cell.

Use Insert > Link when you are adding a one-off destination to selected text, a shape, or a cell and do not need a formula to construct it. On Windows, Ctrl+K opens the link dialog; on Mac, use Command+K. The dialog lets you choose a web address or a location in the workbook, depending on the version and selection. Either method can produce a link that is inaccessible to another person if that person lacks access to its destination.

Changing the cell’s font color or underline is not a reliable repair for a broken link. Formatting affects appearance, not the address. Likewise, a displayed URL is not necessarily clickable if it was pasted into a cell as plain text. Select the cell and use Insert > Link to create a link, or use HYPERLINK with a valid address.

Frequently Asked Questions

Why does clicking a hyperlink only select the Excel cell?
On Windows, hold Ctrl while clicking if Use Ctrl+Click to follow hyperlink is enabled. You can change that option under File > Options > Advanced > Editing options. On Mac, try Command-click if a normal click only selects the cell.

Why does Excel show my HYPERLINK formula as text?
The cell may be formatted as Text, the formula may begin with an apostrophe, or Show Formulas may be on. Set the cell to General, remove an unintended apostrophe, re-enter the formula, and toggle Show Formulas off if the whole sheet displays formulas.

Why does HYPERLINK display a label but open the wrong page?
The second argument controls the displayed label; the first argument controls the destination. Inspect the first argument or the referenced source cell for a typo, an outdated URL, or extra spaces.

Can an Excel hyperlink open a file on my computer?
Yes, a HYPERLINK formula can point to a local file, but the path must exist and the user must have permission to open it. Other people may not have the same drive or folder, and a local path may not work in Excel for the web.

Why does my link work for me but not for a coworker?
The coworker may lack access, use a different file path, or be opening the workbook in a browser that cannot reach a local destination. Share the destination with the right permissions and use a shared location appropriate for the readers.

Does HYPERLINK automatically make pasted web addresses clickable?
No. A plain address may remain text, depending on how it was entered and Excel’s automatic formatting behavior. Use Insert > Link or create a HYPERLINK formula when you need a link 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.