Excel Hyperlink to Another Sheet Not Working? Fixes

If an Excel hyperlink to another sheet is not working, check that the destination sheet exists and is visible, then recreate the link using Ctrl+K > Place in This Document. For a formula link, use an internal address beginning with #, such as =HYPERLINK("#'Sales Data'!A1","Open Sales Data").

How an Excel sheet hyperlink works

A link to another worksheet in the same workbook is an internal hyperlink. It stores a destination—usually a sheet name and cell address—and takes you there when you follow it. That is different from a link to a website or another workbook, which points outside the current sheet collection and may depend on a file path or network location.

In an internal hyperlink address, the leading number sign tells Excel that the destination is within the current workbook. A sheet name containing spaces or certain punctuation should be enclosed in single quotation marks. For example, a link to cell A1 on a sheet named Sales Data needs the quoted sheet name. If the sheet is named Summary, quotation marks are not usually necessary, but using them consistently can make links easier to inspect.

A hyperlink does not create a worksheet, unhide a hidden one, or correct a destination that has changed. It simply points to the location recorded in the link. If the sheet is renamed, deleted, hidden, or moved to another workbook, the stored destination may no longer be usable. That is why identifying the destination before changing the link is the best first step.

Create or replace the link through Excel’s dialog

In Excel for Microsoft 365 on Windows, select the cell that should contain the link, press Ctrl+K, and choose Place in This Document in the Insert Hyperlink dialog. Select the worksheet, enter a cell reference such as A1 if needed, confirm the display text, and choose OK. Click the link to check that it opens the intended sheet.

If the cell already contains a hyperlink, right-click it and choose Edit Hyperlink to inspect its destination. Depending on the cell and Excel build, the dialog may show different labels, but the key is to choose a location inside the current workbook rather than a web page or an existing file. Recreating a stale link this way is often safer than trying to guess which part of an old address is wrong.

Confirm the destination sheet’s name in the workbook tabs.
Choose a cell that exists on that sheet, such as A1 or the top-left cell of the relevant table.
Use meaningful display text, such as “Open monthly totals,” so readers know where the link goes.
Test the link after saving, especially if the workbook will be shared.

On a Mac, the keyboard shortcut is generally Command+K rather than Ctrl+K; use the link dialog’s option for a location in the current workbook. Excel for the web has a browser-based link interface, and its labels or available destination choices can differ from the Windows desktop dialog. If the web interface does not offer the required sheet destination, open the workbook in the desktop app to create or repair it.

Use the HYPERLINK formula for a clickable cell

A formula is useful when you want a consistent link label or need to generate links in multiple cells. With the formula entered in any cell on the current worksheet, it displays the text “Open Sales Data” and links to A1 on the Sales Data sheet:

=HYPERLINK("#'Sales Data'!A1","Open Sales Data")

For a sheet called Summary, a link to its A1 cell can be written as follows. The leading # and the quoted destination are important parts of the internal address:

=HYPERLINK("#'Summary'!A1","Go to Summary")

In both examples, the first HYPERLINK argument is the destination and the second is the text shown in the cell. The cell address can be changed to a useful starting point, such as D10, but it must refer to a valid cell on the named sheet. If the formula is displayed literally instead of producing a link, check whether the cell is formatted as Text or whether an apostrophe was entered before the equals sign. Change the cell format to General, re-enter the formula, and press Enter.

When you type a formula, use the commas shown above in standard English-language Excel syntax. Some regional settings use different list separators, so Excel may request the separator configured for that installation. If the formula returns an error, first verify the sheet spelling, punctuation, quotation marks, and destination cell rather than assuming that the HYPERLINK function itself is unavailable.

Check common causes of a link that does nothing

A link can look correct but fail because Excel is not following it when clicked, or because the destination cannot be reached. Check these possibilities before rebuilding the entire workbook:

The cell is not actually a hyperlink. Blue underlined text can be ordinary formatting. Right-click the cell and look for Edit Hyperlink, or inspect the formula bar for a HYPERLINK formula.
The destination sheet is hidden. A hyperlink cannot make a hidden worksheet visible. Right-click a sheet tab, choose Unhide, and select the destination. If Unhide is unavailable, workbook structure protection may be preventing changes.
The sheet name is outdated or misspelled. A renamed sheet can leave a stored text address pointing at its former name. Compare the address with the actual tab name, including spaces.
The address points to a cell or sheet that no longer exists. An invalid reference can produce an error or fail to take the expected route. Edit the link and choose a valid cell on the correct sheet.
The link is being edited rather than followed. A single click may select the cell. In Excel’s Windows settings, check File > Options > Advanced > Editing options for the “Use Ctrl+Click to follow hyperlink” setting. Follow the behavior indicated by that setting.
The displayed text is misleading. A cell may say “Summary” while its actual destination points elsewhere. Use Edit Hyperlink to check the real target; do not rely only on the label.

If the workbook is protected, distinguish worksheet protection from workbook-structure protection. Worksheet protection limits edits to cells and other sheet contents; workbook-structure protection can restrict actions such as hiding, unhiding, moving, or renaming sheets. You may need the workbook owner or password to make the necessary change. Do not remove protection without permission.

Diagnose errors and unexpected destinations

If Excel reports that the reference is not valid, inspect the sheet name and cell address first. For a name with spaces, keep the single quotation marks around the sheet name inside the hyperlink address. Also check for an accidental extra apostrophe, missing exclamation point between the sheet name and cell, or a reference to a sheet that was deleted.

If clicking opens a browser, another workbook, or a file dialog instead of changing sheets, the link may be an external address rather than an internal one. Right-click the cell and choose Edit Hyperlink. Replace the external destination with a location in the current document, or use a HYPERLINK formula whose first argument begins with # and names the intended sheet and cell.

If the formula shows as text, check for Text formatting and for an initial apostrophe. If the cell displays an error, use the formula bar to inspect the whole formula; a narrow column can hide the displayed result but does not by itself break the link. You can also temporarily widen the column to distinguish a display issue from a formula problem.

For a workbook received from someone else, make sure you are looking at the current saved version. A link may have been repaired in one copy while you are opening an older attachment or a duplicate from another folder. Save a copy under a clear filename before making broad repairs, and test a few representative links before replacing many at once.

Keep links reliable when sheets are renamed or shared

Internal links that store a sheet address are not the same as links that locate information by a stable identifier. Renaming a sheet can make a text-based hyperlink stale, especially when its destination was typed into a formula or dialog. After renaming a sheet, test links that point to it and update them if necessary. Deleting and recreating a sheet with the old name does not guarantee that every old hyperlink will be repaired.

For a workbook that will be shared, use clear, stable sheet names and avoid relying on a particular user’s local file path for internal navigation. A link to another sheet inside the same workbook normally travels with that workbook; a link to a separate workbook can break when the file is moved, renamed, or unavailable to the recipient. Keep external workbook links distinct from internal sheet links when troubleshooting.

It also helps to give destinations meaningful labels and place links in a predictable area, such as a navigation sheet. If several links point to the same sheet, test one after any sheet rename and then review the others. A link that opens A1 may appear to do nothing if the useful content is far down the sheet, so point it to a relevant starting cell or add a clear heading near the destination.

When to use a hyperlink and when to use another method

A hyperlink is best when someone should click a cell to navigate, particularly in a contents page, dashboard, or workbook index. It does not automatically update a value when source data changes; it is navigation, not a formula that retrieves or summarizes data. To display information from another worksheet, use an appropriate cell reference or lookup formula instead of expecting a hyperlink to bring the value into the current cell.

If the goal is to jump to a sheet while editing, clicking its tab is the simplest alternative. For a large workbook, the sheet navigation controls and the list of sheet tabs can help locate a worksheet without maintaining a separate link. If the goal is to find a particular value, Excel’s Find command or a lookup formula is more suitable than a link that only opens a fixed cell.

Use an internal hyperlink when navigation is the intended action, and a formula or a direct tab selection when the task is calculation or browsing. Choosing the right method avoids a common misconception: a clickable link does not create a live connection between the contents of two cells.

Frequently Asked Questions

Why does my Excel hyperlink say the reference is not valid?

The stored sheet name or cell address may no longer exist, or the address may be formatted incorrectly. Check the exact sheet-tab name, use quotation marks around a name with spaces, and choose a valid destination cell such as A1.

How do I link to a sheet with spaces in its name?

Put the sheet name in single quotation marks in the internal address. For example, the formula shown earlier uses #'Sales Data'!A1 as its destination. You can also select the sheet from Place in This Document instead of typing its name.

Why does clicking my link not open the hidden sheet?

A hyperlink does not unhide a worksheet. Unhide the sheet first by right-clicking a sheet tab and choosing Unhide, if workbook permissions allow it, then update or test the link again.

Does a link to another sheet work after I rename the sheet?

Do not assume that every stored hyperlink will update when a sheet is renamed. Test the affected links and repair any destination that still uses the old name. Links created through formulas are especially easy to inspect because the destination is visible in the formula.

Why is my HYPERLINK formula showing as text?

The cell may be formatted as Text, or the entry may begin with an apostrophe. Change the format to General, re-enter the formula, and press Enter. Also make sure the formula begins with an equals sign.

Can I link to another workbook with the same method?

You can create links to other files, but those are external links and are affected by file location, access, and permissions. For navigation within the current workbook, choose Place in This Document or use an internal address beginning with #.

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.