'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel OneDrive Hyperlinks Changing to Invalid Relative Paths
Question details
Users are experiencing issues where hyperlinks to other workbooks in Excel for the web automatically format into broken relative paths, resulting in an error when clicked.
- Product
- Excel for the web, OneDrive, SharePoint
- Device & OS
- not provided
- Scenario
- Creating a hyperlink inside an Excel workbook stored in OneDrive or SharePoint that redirects to another online workbook.
- Observed behavior
- The absolute URL pasted into the hyperlink is dynamically rewritten into an invalid relative path that combines the source workbook's location and the target's location, breaking the link.
Before troubleshooting, verify that the target workbook hasn't been moved, deleted, or renamed, and ensure your internet connection is stable.
Test Links Directly and Compare with Excel Desktop
Verify if the issue is strictly isolated to Excel for the web by testing the target URL directly and comparing its behavior with the Excel desktop application.
Excel for the web sometimes attempts to optimize URLs between files in the same cloud environment, which can lead to miscalculated relative paths. Testing in the desktop app bypasses this web-specific behavior.
Copy the hyperlink you want to use, open a new browser tab, and paste the URL directly into the address bar to ensure the target file opens correctly.
Instead of using the web browser, open the source workbook using the Microsoft Excel desktop application.
Insert the absolute URL into the desired cell using the 'Insert Link' feature. Click the link to confirm it routes correctly without auto-resolving into a relative path.
Flush DNS Cache to Resolve Network Conflicts
Clear your computer's DNS cache to resolve any underlying network or connectivity conflicts that might be affecting Office online services.
Contact Microsoft 365 Support with HAR Logs
Since this is often an unexpected service behavior in Excel Online, it requires investigation by Microsoft's development team via HAR (HTTP Archive) logs.
Try WPS Office for Reliable File Linking and Management
If Microsoft Excel's web platform keeps breaking your hyperlinks due to auto-formatting bugs, consider switching to WPS Office. It provides a stable, lightweight desktop experience with highly reliable hyperlink handling, making cross-document referencing hassle-free.
- 1. Download the software: Visit the official WPS Office website and download the free desktop application.
- 2. Install WPS Office: Run the installer and follow the simple on-screen instructions to set up the software on your device.
- 3. Open and edit your files: Open your existing .xlsx files directly in WPS Spreadsheet and manage your hyperlinks reliably.
Frequently Asked Questions
Why do my Excel web links change to relative paths automatically?
Excel for the web sometimes incorrectly tries to optimize URLs between files stored in the same SharePoint or OneDrive environment by converting absolute URLs to relative paths. If the service miscalculates the directory structure, it results in invalid, broken links.
Can I disable relative links in Excel for the web?
Currently, Excel for the web does not offer a direct setting to disable automatic relative hyperlink generation. However, using the Excel Desktop application typically bypasses this cloud-specific auto-formatting behavior.
How do I collect HAR logs for Microsoft Support?
Open your web browser's Developer Tools (usually by pressing F12 or right-clicking and selecting 'Inspect'). Go to the 'Network' tab, ensure the 'Preserve log' option is checked, reproduce the hyperlink error in Excel for the web, and then click the 'Export HAR' (or download) icon to save the log file.
