Excel Sheet Hyperlink Not Working? How to Fix It

If an Excel hyperlink seems unresponsive, first try Ctrl+clicking its cell on Windows: Excel normally uses a regular click to select a cell and Ctrl+click to follow the link. If that does not open the destination, right-click the cell, choose Edit Hyperlink, and check that the address or workbook location is correct and still accessible.

Start with the click behavior

A link that appears not to work may simply be waiting for the right action. In Excel for Microsoft 365 on Windows, the default behavior is to select a cell with a click and follow its hyperlink with Ctrl+click. Hover over the cell to see whether the pointer or status information indicates a link, then hold Ctrl while clicking. On a Mac, the modifier and interaction can differ by Excel version and input device; try Command-click, or use the cell’s context menu to inspect or open the link.

Also check whether the cell actually contains a hyperlink. Blue, underlined text is a common style, but formatting alone does not create a link. Conversely, a real hyperlink can use ordinary formatting and may not look like a link. Right-click the cell: if Edit Hyperlink or a similar link-editing command appears, Excel recognizes a link. If not, the cell may only contain text.

Try the expected click action before changing workbook settings.
Right-click the cell and look for Edit Hyperlink or Open Hyperlink.
Copy the destination, if available, and test it separately in a browser or File Explorer.

Check whether the destination is still valid

A hyperlink stores a destination, not a guarantee that the destination will remain in place. A web link may have been moved, deleted, or changed by its owner. A link to a file may point to a folder on another computer, a network drive that is disconnected, or a file that has been renamed. If the link opens an error page or a “cannot find” message, the problem is usually the destination or access to it rather than Excel’s click behavior.

Right-click the cell and choose Edit Hyperlink to inspect the address. In the dialog, confirm the full URL, file path, or workbook-and-cell reference. Look for misspellings, missing folder names, an old filename, or an address that ends in the wrong file extension. If the destination is a web page, paste its address into a browser. If it is a file, check that the file exists at that location and that you have permission to open it.

Links to files on a local drive can work only on the computer or account where that path is available. For example, a link to C:\Users\Sam\Documents\Plan.xlsx is unlikely to work for a colleague whose Windows account or folder structure differs. A shared OneDrive or SharePoint link is often more suitable for collaboration, but the recipient still needs permission and may need to sign in to the correct account.

Repair or create the hyperlink again

If the destination is wrong, edit the existing link rather than changing only the visible cell text. On Windows, right-click the cell and select Edit Hyperlink, correct the destination, and confirm. To create a new link, select the cell or text, press Ctrl+K, enter or choose the destination in the Insert Hyperlink dialog, and confirm. You can also use Insert > Link on the ribbon. In Excel for Mac, Command+K is the usual shortcut; the dialog labels and layout can differ slightly.

When linking to a web page, include the complete address, such as https://www.example.com/guide. A shortened or incomplete address can be interpreted differently from the intended website. When linking to a file, use Browse or the dialog’s file selection option where available, so you can choose the actual file instead of typing a path from memory. After saving, click the link again to confirm that it points to the intended destination.

If the link is visible but Excel treats it as plain text, select the cell and press Ctrl+K to attach a destination. Typing a web address into a cell does not always turn existing text into a working hyperlink. Excel’s AutoFormat As You Type option can automatically recognize some internet and network addresses as they are entered, but it does not retroactively convert every existing address. On Windows, check File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and look for Internet and network paths with hyperlinks.

Understand links to other sheets and workbooks

A hyperlink can point to a website, a file, or a location within a workbook. A link intended to jump to another worksheet can fail if the sheet was renamed, deleted, or moved to a different workbook. Re-create an internal link using Insert > Link and choose the option for a location in the current document, then select the correct sheet and cell. The wording in the dialog can vary slightly across versions.

For a link to another workbook, check both the workbook name and the target sheet or cell. If the target workbook has moved, Excel may still retain the old path. Open the target workbook from its current location, then update the source link to that location. When a workbook is shared, confirm that other users can access the same destination; a link that works for its author may point to a private folder unavailable to everyone else.

Do not confuse a hyperlink with an external workbook reference. A hyperlink is a clickable route to a destination. A formula such as a reference to another workbook retrieves or calculates data. Updating a workbook’s external links may change formulas, but it does not necessarily repair a clickable hyperlink, and changing a hyperlink will not update formulas that refer to another file.

Check a HYPERLINK formula

Some worksheets create links with Excel’s HYPERLINK function instead of the Insert Link dialog. If a formula-generated link is not behaving as expected, select the cell and inspect the formula bar. Confirm that the destination is spelled correctly and that the friendly text is not being mistaken for the destination. The function can create links to web pages, files, or workbook locations, but the destination still has to exist and be reachable.

For example, with the destination URL in A2 and the label in B2, enter this in C2: =HYPERLINK(A2,B2). If A2 contains https://www.example.com/guide and B2 contains Open guide, C2 displays Open guide as a clickable link to that address. This example does not require the destination to be the same text shown in the cell. If the formula itself is displayed instead of a result, check whether the cell is formatted as Text or whether Show Formulas is enabled; change the cell to General, re-enter the formula, or toggle Show Formulas from the Formulas tab.

HYPERLINK formulas do not bypass access restrictions. A formula pointing to a file on an unavailable drive can still fail, and a link to a private page still requires permission. If only formula-created links fail while manually inserted links work, compare the exact destination values and check for extra spaces or incomplete URLs in the cells that supply the formula arguments.

Review settings, file format, and security prompts

On Windows, Excel’s click setting is under File > Options > Advanced > Editing options. The checkbox Use Ctrl+Click to follow hyperlink controls whether Ctrl is needed. If it is cleared, a normal click may follow the link instead. Change this only if the alternative behavior suits your workflow; the default can help prevent accidental navigation while selecting cells.

Make sure the workbook is saved in a format that supports Excel features, such as .xlsx or .xlsm. CSV is a plain-text data format and does not preserve workbook features such as clickable hyperlink objects, formulas, and formatting in the same way. If a file was exported to CSV and reopened, the address may appear as text rather than as a functioning Excel hyperlink. Create the link again in the workbook and save it as an Excel workbook.

Excel or Windows may show a security prompt before opening a link, especially when a workbook or destination came from the internet or an unfamiliar source. Read the prompt and verify that you trust the file and destination before proceeding. Do not disable security protections just to make an unknown link open. If a workbook is in Protected View, enable editing only when its origin is trustworthy and your organization’s policies allow it.

When the problem affects only one user or device

If a link works for one person but not another, compare the destination and access conditions before rebuilding the workbook. The second user may lack permission, be signed into a different Microsoft account, have a disconnected network drive, or use a different folder path. Ask them to open the destination directly, outside Excel. If that also fails, the issue is likely access or location rather than the hyperlink itself.

If the link fails only in Excel for the web, try opening the workbook in the desktop app, or test the destination in the browser. Some file paths and actions behave differently between desktop Excel and a browser because the web app cannot access a computer’s local folders as if it were running on that computer. Shared cloud links are generally more appropriate than local paths for people opening a workbook online. For managed work or school accounts, an administrator’s sharing or security policies may also affect access.

Frequently Asked Questions

Why do I have to press Ctrl to open a hyperlink in Excel?

Excel for Windows normally uses a click to select the cell and Ctrl+click to follow its hyperlink. This helps avoid opening a link when you are trying to select or edit the cell. You can review the behavior under File > Options > Advanced > Editing options by checking Use Ctrl+Click to follow hyperlink.

Why is my hyperlink blue but not clickable?

Blue, underlined formatting does not prove that a hyperlink exists. Right-click the cell and see whether Excel offers a link-editing command. If it does not, create a link with Ctrl+K on Windows or Command+K on Mac, then enter the destination.

Why does an Excel hyperlink say it cannot open the specified file?

The file may have moved, been renamed, or become unavailable, or you may not have permission to access it. Inspect the destination with Edit Hyperlink, then check that the file exists at that path and can be opened outside Excel. For shared workbooks, use a location or sharing link available to the intended users.

How do I make a link jump to another sheet?

Select the cell, choose Insert > Link, and use the option for a location in the current document. Choose the target worksheet and cell, then confirm. If the target sheet was renamed or deleted later, edit or recreate the link.

Will saving an Excel file as CSV keep its hyperlinks?

CSV does not preserve Excel workbook features as an .xlsx file does. A URL may remain as text, but the hyperlink object, formula, or workbook formatting may not survive as expected. Keep a copy in .xlsx or .xlsm when you need working Excel hyperlinks.

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.