How to Fix Excel Hyperlinks with Incorrect Addresses or Display Text
Question details
The user needs to correct Excel hyperlinks that have truncated file paths or display text that does not match the actual destination.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Clicking a hyperlink in a spreadsheet or reviewing document links.
- Observed behavior
- The hyperlink shows incorrect display text, or the address path is cut off at the first folder, preventing the user from reaching the intended file or folder.
Ensure you have the exact correct file or website path copied to your clipboard before editing the broken hyperlink. If linking to a local file, verify that the file has not been moved or renamed.
Fix Hyperlinks using the Edit Hyperlink Context Menu
The most straightforward method is to use the right-click menu to manually correct the destination address and the display text.
Right-click the cell containing the incorrect hyperlink.
Choose 'Edit Hyperlink' from the context menu.
At the top of the dialog box, check the 'Text to display' field and update it to accurately reflect the link.
In the 'Address' field at the bottom, paste or type the complete, unbroken file or folder path. Click 'OK' to save.

Correct Links Created by the HYPERLINK Formula
If the link was generated using a formula, you must edit the formula syntax directly within the cell.
Easily Manage and Edit Hyperlinks with WPS Office
WPS Office provides a highly compatible spreadsheet tool that makes creating, editing, and fixing hyperlinks a breeze. You can easily correct paths, update display texts, and manage bulk links with its intuitive interface.
- 1. Open your file in WPS: Launch WPS Office and open your spreadsheet containing the hyperlinks.
- 2. Right-click the link: Right-click the broken link and select 'Edit Hyperlink'.
- 3. Update details: Modify the 'Text to display' and 'Address' fields with the correct information, then click OK.

Frequently Asked Questions
Why does my Excel hyperlink path stop at the first folder?
This often happens if the file path contains spaces or special characters and wasn't enclosed in quotation marks when generated by a formula, or if the path exceeds Excel's 255-character limit for hyperlinks.
How can I remove a hyperlink without deleting the text?
Right-click the cell containing the hyperlink and select 'Remove Hyperlink' from the context menu. The clickable link will be removed, but the display text will remain in the cell.
Can I use a cell reference for the display text in a hyperlink formula?
Yes, in the =HYPERLINK() formula, you can replace the "text_to_display" string with a cell reference (e.g., =HYPERLINK("C:\folder\file.pdf", A1)), which will use the text in cell A1 as the display text.
What is the maximum character limit for an Excel hyperlink?
Excel limits hyperlink addresses to 255 characters. If your file path or URL is longer than this, the hyperlink will fail or get truncated. You may need to map a network drive or use a URL shortener to bypass this.




