Excel Hyperlink Not Working? How to Fix It
Excel only auto-links URLs you type, so pasted ones stay text. If F2 then Enter fails, use a HYPERLINK formula or a macro that adds the links directly.
2026-10-02
Why your Excel hyperlink is not working
Excel only turns a URL into a link automatically when you type it. Microsoft's own description of the setting is that it "replaces typed URLs, network paths, and email addresses with hyperlinks." Paste, import or fill down a column of addresses and they stay plain text, however much they look like links.
So when pressing F2 then Enter fails, the reliable answer is to stop depending on that automatic behaviour. Below, each symptom is matched to its cause and a fix.
TL;DR: Key takeaways
- Pasted or imported URLs stay text. Excel only auto-links what you type.
- Clicking Stop Automatically Creating Hyperlinks once switches the feature off.
- A HYPERLINK formula showing as text means the cell is formatted as Text.
- A link that says it cannot open the file points at a path that moved.
- When F2 then Enter fails, a HYPERLINK formula or a macro always works.
Match the symptom to the cause
| What you see | Likely cause | Fix |
|---|---|---|
| Pasted URLs are plain text | Excel only auto-links typed URLs | HYPERLINK formula or macro |
| F2 then Enter does nothing | Automatic hyperlinks are switched off | Re-enable in AutoCorrect options |
| The setting is on but it still fails | Relying on automatic formatting at all | HYPERLINK formula or macro |
=HYPERLINK(...) shows as text | Cell formatted as Text | Set General, then F2 and Enter |
| "Cannot open the specified file" | The linked file or folder moved | Edit the link to the new path |
F2 then Enter does nothing
Re-entering a cell asks Excel to treat the URL as freshly typed. That only works while automatic hyperlinks are enabled, and they are easy to switch off by accident.
When Excel creates a link, a small AutoCorrect Options button appears. One of its choices is Stop Automatically Creating Hyperlinks, and clicking it once stops the feature. To turn it back on, follow Microsoft's steps: File > Options > Proofing > AutoCorrect Options, then on the AutoFormat As You Type tab tick Internet and network paths with hyperlinks. On Mac, the same option lives under Excel > Preferences > AutoCorrect.
The setting is already on and it still fails
The most common report, with a simple answer: automatic formatting is a typing convenience, not a conversion tool. Use a method that creates the link explicitly.
A HYPERLINK formula. In a helper column, enter =HYPERLINK(A2) and fill down. Each cell becomes clickable whatever the AutoCorrect setting. The result is a formula, so it updates if the address in A2 changes.
A macro. Our free Bulk Add Hyperlinks macro walks the selection and adds a real hyperlink to each cell directly, so the AutoCorrect setting is irrelevant. It recognises addresses starting with http://, https:// or www., and skips anything else. If your list holds bare domains such as example.com, add https:// to the front first with Add Prefix or Suffix.
Converting text to clickable hyperlinks compares all three methods in more detail.
A HYPERLINK formula shows as text
If the cell shows =HYPERLINK(A2) instead of a link, Excel is not evaluating the formula at all. The usual reason is that the cell was formatted as Text before the formula went in.
The fix, as given in a Microsoft Q&A answer: set the number format to General, then press F2 and Enter without changing anything. Changing the format alone is not enough; the cell has to be re-entered.
The link opens nothing or cannot find the file
A clickable link that fails points at an address that no longer resolves: a typo or dead page for web links, something moved for files and folders.
Links to files store a path, often relative to the workbook. Move or rename the workbook or the target, and the stored path no longer matches. Right-click the cell, choose Edit Hyperlink, and point it at the current location. A Microsoft Q&A thread also notes that a Hyperlink base set in the file's properties can redirect relative links, which is worth checking if many links broke at once.
Frequently asked questions
Why won't Excel make my pasted URLs clickable?
Because Excel only converts URLs that are typed into a cell. Pasted, imported or filled-down addresses stay plain text. Use a HYPERLINK formula or a macro that adds hyperlinks directly, which works on existing text regardless of how it got there.
Why does F2 then Enter not create a hyperlink?
It depends on the automatic hyperlink setting, which may have been switched off by clicking Stop Automatically Creating Hyperlinks. Re-enable it under File > Options > Proofing > AutoCorrect Options. If it is already on and still fails, use a HYPERLINK formula instead.
Why is my HYPERLINK formula showing as text?
The cell is formatted as Text, so Excel stores the formula as text rather than calculating it. Change the format to General, then press F2 and Enter to re-enter the cell. The formula then evaluates and the link becomes clickable.
How do I make a whole column of URLs clickable at once?
Use a HYPERLINK formula in a helper column and fill it down, or run a macro that converts the selection in place. Both work on hundreds of rows at once, unlike F2 then Enter, which handles one cell at a time.
Why does my hyperlink say it cannot open the specified file?
The file or folder it points to has moved or been renamed, so the stored path is wrong. Edit the hyperlink to the new location. If many links broke together, check whether a Hyperlink base is set in the workbook's properties.
What to do next
For a column of existing URLs, skip the automatic route and use the Bulk Add Hyperlinks macro or a HYPERLINK formula. Both behave the same on every machine. To go the other way and strip links back to plain text, see extracting URLs from hyperlinks.