How to Fix Hyperlinks Changing or Breaking in Excel 365
Question details
Users need to resolve an issue where hyperlinks attached to images in an Excel workbook become invalid or break automatically upon reopening the file.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Opening a previously saved Excel workbook that contains images with attached URLs or document links.
- Observed behavior
- The hyperlinks attached to images automatically change to invalid addresses and stop functioning after the workbook is saved and reopened.
Before applying fixes, check if the issue happens with all Excel files or just one, and save a backup copy of your current workbook to a local folder.
Check for Workbook Corruption
Determine if the original Excel file is corrupted by testing the hyperlink feature in a brand-new workbook.
File corruption can cause background metadata, such as image hyperlinks, to scramble or reset upon saving. Moving your data to a clean workbook often resolves this.
Open Excel 365 and click on File > New > Blank workbook to create a completely new file.
Insert a test image, right-click it, and select Link. Paste a valid URL, save the file, close it, and reopen it to see if the link breaks.
If the test link works perfectly, copy the cell contents from your original, problematic workbook and paste them into the new workbook.
Disable Interfering Add-ins via Safe Mode
Start Excel in Safe Mode to check if third-party add-ins are automatically altering your hyperlinks.
Perform an Online Repair or Restore OneDrive Version
Repair the Microsoft 365 installation files or revert to an older, functioning version of the workbook from OneDrive.
Experience Stable Hyperlinks and Workbooks with WPS Office
If Excel 365 continues to corrupt your image hyperlinks, consider switching to WPS Office. It provides a lightweight, stable, and highly compatible spreadsheet environment where object links and formatting are preserved flawlessly.
- 1. Download and Install: Visit the official WPS website and install WPS Office for your operating system.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx file.
- 3. Add and Save Hyperlinks: Right-click any image, easily insert your hyperlink, and save the file with confidence that the address will not break.
Frequently Asked Questions
Why do my Excel hyperlinks change from absolute to relative paths?
Excel has a built-in feature that automatically converts absolute file paths to relative paths upon saving. To stop this, go to File > Options > Advanced, scroll down to General, click 'Web Options', switch to the 'Files' tab, and uncheck 'Update links on save'.
Can I use the HYPERLINK function on an image instead of right-clicking?
No, the HYPERLINK formula function only applies to text within a cell. To link an image, you must either right-click the image and select 'Link', or place a transparent shape with a hyperlink over the cell containing the image.
How do I set a Hyperlink Base to prevent links from breaking?
You can force Excel to use a specific base path for all links. Go to File > Info, click 'Properties' on the right, and select 'Advanced Properties'. In the Summary tab, type your desired base path (e.g., C:\MyFolder\) in the 'Hyperlink base' field and click OK.
