Excel Hyperlink Not Working After Copying? Causes and Fixes

If an Excel hyperlink stops working after you copy it, first check whether the paste kept the hyperlink and whether its destination changed. In Microsoft Excel for Microsoft 365 on Windows, right-click the cell and choose Edit Hyperlink to inspect the address; if you only pasted values, copy the original cell again using a paste option that preserves the link.

What copying does to an Excel hyperlink

A hyperlink can be part of a cell in more than one way. It may be a link added to a cell through Excel’s Insert Link command, or it may be generated by a HYPERLINK formula. The visible text in the cell is not necessarily the destination: a cell that says “Open report” could link to a website, a file, or another place in a workbook.

When you copy a cell normally, Excel generally copies its contents and formatting, including a hyperlink. But the result depends on how you copy and paste. Paste Values is intended to paste displayed values rather than all cell properties, so it can leave the text behind without preserving the link. Copying a formula is different again: Excel can adjust relative cell references in the formula to suit the new location. A hyperlink can therefore still be present but point somewhere unintended.

It also matters what is being copied. Copying a worksheet cell inside Excel is not the same as copying text from a web page or email and pasting it into Excel. The latter may bring in plain text, formatting, or a link depending on the source and paste choice. Check the destination cell rather than assuming that the appearance of blue, underlined text proves a working hyperlink.

Check whether the link is missing or merely hard to follow

Before rebuilding a link, determine what “not working” means. If the cell has no hyperlink, its text may simply have been copied without the link. If Excel opens a different page or file, the link exists but its address is wrong or no longer valid. If nothing happens when you click, Excel may be waiting for a modifier key, or a warning or application prompt may be in the way.

On Windows, Excel commonly requires Ctrl+click to follow a hyperlink while a cell is selected normally with a click. To check the setting, open File > Options > Advanced and look under Editing options for Use Ctrl+Click to follow hyperlink. If that option is selected, hold Ctrl while clicking the link. If it is cleared, a normal click follows the link. This setting changes how you activate a link; it does not repair a broken destination.

On a Mac, the key combination and interface can differ from Windows; try the modifier-key prompt shown by Excel, or use the context menu to follow the link. Excel for the web also has browser-specific click behavior. If you are unsure, right-click the cell and choose the command to open or follow the hyperlink. If that works, the link itself may be sound and the issue may simply be how it was clicked.

Inspect and repair the copied destination

In Excel for Microsoft 365 on Windows, right-click the cell and choose Edit Hyperlink. Review the address or file path in the dialog. If it is a website, check that the address includes the intended domain and has not been cut off. If it is a workbook location, check the file name, folder, and any sheet or cell reference. Choose OK after correcting the destination.

You can also select the cell and use Insert > Link on the ribbon to add or edit a link. The keyboard shortcut is Ctrl+K on Windows and Command+K in many Mac versions of Excel. If the dialog shows a link to a file that has moved, browse to its new location or enter the correct address. A copied link cannot automatically know that a file has been renamed or relocated.

For a quick test, right-click and copy the destination shown in the link editor, then paste it into a browser or File Explorer. A website that fails outside Excel may be unavailable, mistyped, or blocked by the network. A file link that fails outside Excel may point to a missing file or a folder the current user cannot access. This separates an Excel click-setting issue from a destination or permission problem.

Use the right paste method

If the hyperlink was stripped during pasting, repeat the copy from the original cell and choose a paste method that includes the link. Start with the ordinary Paste command or the relevant paste option shown in Excel’s paste menu. Avoid Paste Values when you need the original hyperlink behavior. Paste options can vary with the source, destination, and Excel version, so check the resulting cell by opening its context menu.

When copying between workbooks, make sure you are copying the cell itself in Excel, not just the visible text in the formula bar or a copied value from another application. If the link must be retained but the cell’s formatting should not, test the available paste choices on a spare cell first. Some paste options preserve formulas or values but not every property of the original cell.

To retain the link and formatting: use ordinary Paste, then verify the link.
To retain the displayed text only: Paste Values may be appropriate, but expect the hyperlink not to be included.
To rebuild the link: select the destination cell, choose Insert > Link, and enter the intended address.

For a dependable handoff to another person, include the destination as visible text or document the file location as well as providing a clickable link. That makes it easier to recover the destination if a particular paste method or application does not preserve the hyperlink.

Check formulas and relative references

A formula-based hyperlink can change when copied because Excel adjusts relative references. For example, with website addresses in A2:A3 and link labels in B2:B3, enter this formula in C2:

=HYPERLINK(A2,B2)

If A2 contains https://example.com and B2 contains Open example, C2 displays a clickable link labeled “Open example.” Copying C2 down one row changes the references to A3 and B3, which is usually useful when each row has a different destination. If A3 is blank or contains the wrong address, the copied link may appear broken or lead to the wrong place.

To diagnose a formula link, select the cell and inspect the formula bar. Confirm that the address reference still points to the intended cell and that the source address is complete. If you meant every copied formula to use one fixed address, use absolute references for that address. For example, with the fixed URL in A2 and a label in B2, enter =HYPERLINK($A$2,B2) in C2. Copying down keeps the address tied to A2 while the label reference changes by row. The formula must be entered in a cell separate from the URL and label cells to avoid replacing those inputs.

Formula links and manually inserted links have different editing clues. A formula-generated link shows a formula beginning with =HYPERLINK in the formula bar. A manually inserted link may show ordinary cell text there, with its destination available through Edit Hyperlink. Do not assume that replacing visible text will also change a formula’s destination.

Relative file paths, moved workbooks, and permissions

Links to local files and shared folders are especially likely to fail after copying or moving a workbook. A link may refer to a path on the original author’s computer, a network drive letter unavailable to another user, or a file that has since been renamed. A workbook copied to a different folder can also change the context in which a relative file path is resolved. The cell may still contain a hyperlink, even though the intended file is no longer at that location.

For a team, prefer a location all intended readers can access, such as an appropriately shared SharePoint or OneDrive location, rather than a personal folder. Confirm that recipients have permission to open the target; a valid link does not grant access by itself. If the file is moved again, update the link and notify users who may have older copies of the workbook.

Be careful with links to files on removable drives or mapped network drives. Another computer may assign a different drive letter or may not have the drive connected. If a link works for you but not a colleague, compare the actual destination and access permissions on both computers before concluding that the copied cell is defective.

Security prompts and external-link confusion

Excel may show a security warning before opening a link, especially when the destination is external or the workbook came from an untrusted source. Read the prompt and confirm that the address is expected before continuing. A warning is not proof that copying damaged the hyperlink, and it should not be bypassed automatically. If the destination is unexpected, do not open it until you have confirmed its source.

Also distinguish a clickable hyperlink from an external workbook link. A hyperlink is something a user follows to a web page, file, or location. An external workbook link is a reference used by a formula to retrieve data from another workbook. The two can both involve another file, but repairing one does not necessarily repair the other. A cell that displays an error from a linked formula is not necessarily a hyperlink problem.

If Excel opens the wrong application or nothing useful happens after following a valid web link, check whether the address opens outside Excel and whether the computer has a default browser configured. If a file opens in a warning or Protected View, follow your organization’s security rules rather than changing workbook security settings simply to make the link open.

A reliable troubleshooting sequence

Use this order to avoid rebuilding a link before identifying the cause:

Try the correct click method, including Ctrl+click on Windows if the setting is enabled.
Right-click the cell and look for a command to edit or follow the hyperlink. If no hyperlink command is available, the link may not have been copied.
Choose Edit Hyperlink and inspect the full destination, including any file path or workbook location.
If the cell contains a formula, inspect its references in the formula bar and compare them with the source cells.
Test the destination outside Excel and confirm that the file exists, the website is reachable, and the user has permission.
If the link is missing, copy the original cell again using ordinary Paste or recreate the link with Insert > Link.

After repairing one link, test it before filling or copying the fix across a large range. For formula-driven lists, verify several rows, including the first and last copied rows. A single successful link does not prove every row points to the correct destination.

Frequently Asked Questions

Why does my Excel hyperlink become plain text after copying?
It may have been copied with a values-only paste option, or it may have been copied from an application that supplied only text. Copy the original cell in Excel and use ordinary Paste, or add the link again with Insert > Link.

Why does the copied hyperlink open the wrong file or page?
The copied destination may be wrong, a file may have moved, or a HYPERLINK formula may now refer to a different row. Inspect the destination with Edit Hyperlink or check the formula and its cell references.

Why do I have to hold Ctrl to open a hyperlink in Excel?
On Windows, Excel’s Use Ctrl+Click to follow hyperlink setting controls this behavior. Find it under File > Options > Advanced, in Editing options. It affects how links are activated, not where they point.

Will a hyperlink still work if I email the workbook to someone?
Not always. A local or network file path may only work on your computer, and the recipient may not have permission to access a shared file. Use a shared destination the recipient can reach and test access with the intended account.

How can I copy a hyperlink without copying its formatting?
Paste options differ by source and Excel version. Test the available options on a spare cell, then verify the destination using Edit Hyperlink. If a paste choice removes the link, recreate it in the destination cell rather than relying on its appearance.

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.