Hyperlink Formula Not Working in Excel? Fixes That Help

If an Excel HYPERLINK formula is not working, first check that the cell is not formatted as Text, the formula begins with an equals sign, and its arguments use the separator your Excel settings expect. In Microsoft 365 for Windows, a basic working example is =HYPERLINK("https://www.microsoft.com","Open Microsoft"); if it still will not open, check the destination, calculation settings, and whether you are using Excel for the web.

What the HYPERLINK formula does

HYPERLINK creates a clickable link in a worksheet. Its first argument is the destination, called link_location; its optional second argument is the text displayed in the cell, called friendly_name. If you leave out the second argument, Excel displays the destination itself. The destination can be a web address, a file path, or an in-workbook cell reference, provided the destination is valid and accessible in the Excel environment you are using.

The formula returns a link, not a preview of the destination. For example, the cell might display Open Microsoft rather than the full web address. The cell’s appearance is not a reliable test on its own: formatting can change the color or underline, while a formula that looks like ordinary text might not be an active link at all.

With the destination in A2 and the display text in B2, enter =HYPERLINK(A2,B2) in C2. If A2 contains https://www.microsoft.com and B2 contains Microsoft home page, C2 displays Microsoft home page and links to that website. This arrangement is useful for lists because you can change the destination or label without rewriting the formula.

Check the formula syntax and argument separator

Excel’s function name is HYPERLINK. The destination must be the first argument; the display label, if supplied, comes second. Text typed directly into a formula needs straight quotation marks. A missing quote, a misplaced comma, or an unclosed parenthesis can stop Excel from accepting the formula or send it to an unintended destination.

With no cell references required, this correctly formed formula links to an example page and shows a short label: =HYPERLINK("https://example.com","Visit the example site"). The URL is illustrative; replace it with the actual address you want. Include the protocol, such as https://, for a web link rather than assuming Excel will infer it correctly.

Excel normally shows commas between function arguments in the examples here. Some regional settings use a semicolon as the list separator instead. If Excel rejects a formula with commas, check the separator used by another working formula on that computer or use the separator required by your regional settings. This is a settings difference, not a different HYPERLINK function.

Confirm that the first argument points to the destination and the second, if present, is the visible label.
Use straight quotation marks around text values, and make sure every opening parenthesis and quote has a matching partner.
Check that a web destination starts with a complete address, such as https://example.com/page.
If Excel displays an error while entering the formula, try the local argument separator and inspect the formula bar for typing mistakes.

When Excel displays the formula instead of a link

If you can see =HYPERLINK(...) in the cell instead of a result, Excel may be treating the entry as text. Select the cell and check Home > Number Format. If the format is Text, change it to General, then edit and re-enter the formula; changing the format alone may not convert a formula that Excel already stored as text. Press F2 and then Enter on Windows to re-enter the selected cell’s contents. On a Mac, use Control+U to edit the active cell, then Return to confirm.

Also check for an apostrophe before the equals sign. An entry such as '=HYPERLINK(...) is deliberately stored as text, so remove the leading apostrophe if you want Excel to calculate it. Another possibility is that Show Formulas is enabled, which displays formulas across the worksheet rather than their results. On Windows, toggle it with Ctrl+` (the grave-accent key); you can also check Formulas > Show Formulas. The shortcut can vary with keyboard layout.

If only one formula fails to update, press F2 and Enter after correcting it. If many formulas remain unchanged, check Formulas > Calculation Options and select Automatic if that is appropriate for the workbook. In Manual calculation mode, Excel may not recalculate formulas when their inputs change. Changing calculation mode affects the workbook’s calculations generally, not just hyperlinks, so consider the consequences for a large workbook.

Repair broken destinations and cell references

A correctly entered HYPERLINK formula can still point to the wrong place. Check for spaces or missing characters in the URL, an outdated filename, a renamed worksheet, or a reference to an empty cell. If the destination is stored in another cell, inspect that source cell directly; a formula can be syntactically valid while its destination value is incomplete.

With a web address in A2, this formula uses the value in A2 as the destination and displays Open page: =HYPERLINK(A2,"Open page"). If A2 is blank, has only part of an address, or contains a typo, the generated link will not behave as intended. Test the address by copying it from the source cell and checking that it opens in a browser.

For a link to a worksheet cell in the same workbook, put a hash sign before the reference in the destination text. With a sheet named Sheet2, this formula displays Go to Sheet2 and targets cell A1: =HYPERLINK("#Sheet2!A1","Go to Sheet2"). A sheet name containing spaces needs single quotation marks around the name within the reference, for example #'Sales Data'!A1. The quotation marks are part of the destination text, which itself is enclosed in the formula’s double quotation marks.

File links need extra care because a path that works on one computer may not work for someone else. A path to a local drive may not exist on another user’s machine; a network location may require access permissions or a VPN. For shared workbooks, prefer a destination that all intended readers can reach, such as a properly shared cloud link, and verify access using the intended account. Moving or renaming a linked file can also make a previously working destination fail.

Excel for the web, Mac, and desktop differences

Excel for the web supports HYPERLINK, but Microsoft documents a limitation: the function is for web addresses there. A formula intended to open a local file or navigate to a workbook location may not behave as it does in the Windows desktop app. If a web link works in the browser but a local or internal destination does not, open the workbook in desktop Excel and check the destination type before changing the formula.

Excel for Mac also supports HYPERLINK, although menu names and keyboard shortcuts can differ from Windows, and a file path must make sense on the Mac. A Windows path such as one beginning with a drive letter will not identify the same location on a Mac. For links shared across platforms, use a destination available to both systems, and test it in the version and account your readers will use.

Do not confuse inserting a hyperlink with writing the HYPERLINK function. In desktop Excel, you can add a link through Insert > Link without using a formula. That option is handy for a one-off link; the formula is useful when the destination or label is assembled from worksheet values. The two approaches have different editing workflows, but either can produce a clickable destination.

Check whether the link is present but hard to follow

A hyperlink may exist even when the cell does not look blue and underlined. Cell formatting, a workbook theme, or copied formatting can change its appearance. Select the cell and inspect the formula bar: a HYPERLINK formula indicates a formula-generated link. For a link inserted through the ribbon, right-click the cell and look for link-related options, or use Insert > Link to inspect or edit the destination.

In Excel for Windows, the setting Use Ctrl+Click to follow hyperlink can affect how you open a link. If a normal click selects the cell instead of navigating, try Ctrl+click. You can find the setting under File > Options > Advanced, in the Editing options section. If the destination still does not open, try copying the URL into a browser; that helps distinguish an Excel click behavior from a bad address or an access problem.

Excel may show a security warning before opening some external destinations. Treat that warning as a prompt to verify the address, not as an error to bypass automatically. Check the spelling and domain, and only open files or websites you trust. A hyperlink points to a destination; it does not make an unknown destination safe.

A practical troubleshooting order

Use these checks from quickest to more involved. After each change, try the link again so you can identify what fixed it rather than changing several workbook settings at once.

Click the cell and inspect the formula bar. Confirm that the entry starts with an equals sign and that Excel is showing a result rather than literal formula text.
Check the destination value and test a web address in a browser. Confirm that the file or worksheet reference still exists and that you have permission to access it.
Review the argument order, quotation marks, parentheses, and regional list separator. Compare the formula with a working example in the same Excel installation.
If the formula is stored as text, change the cell format to General and re-enter it. Check for a leading apostrophe and whether Show Formulas is on.
For stale results, check Formulas > Calculation Options. For a link that selects rather than opens, check the Ctrl+Click setting on Windows.
If the workbook is in Excel for the web, determine whether the destination is a web address or a desktop-only location. Try the desktop app for local paths or workbook navigation.

Frequently Asked Questions

Why does Excel show the HYPERLINK formula as text?
Most often, the cell is formatted as Text, the formula has a leading apostrophe, or Show Formulas is enabled. Set the cell to General and re-enter the formula; changing the format without re-entering may not be enough.

Why does my HYPERLINK formula return an error?
Check for incorrect argument order, unmatched quotes or parentheses, and a separator that does not match your regional settings. Then verify that the destination value is complete and valid. A formula can be well formed yet still refer to an inaccessible file or address.

Why does the link work on my computer but not someone else’s?
The other person may not have access to the destination, or a local drive path may not exist on their computer. Use a shared destination they can reach, and confirm permissions and sign-in requirements rather than relying on your own local path.

Can HYPERLINK open a file in Excel for the web?
Excel for the web’s HYPERLINK support is intended for web addresses, not the same range of local file and workbook destinations available in desktop Excel. Use a suitable web link or try the desktop app for a local path.

Why does clicking the link select the cell instead of opening it?
In Windows desktop Excel, Use Ctrl+Click to follow hyperlink may be enabled. Try Ctrl+click, or review File > Options > Advanced. If the link still fails, verify the destination and your access to it.

Can I create a hyperlink without a formula?
Yes. In desktop Excel, select a cell and use Insert > Link to add a link manually. This is convenient for a fixed destination; HYPERLINK is more useful when the destination or displayed label should come from cell values.

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.