Fix Excel SharePoint Hyperlinks Changing to OneDrive URLs
Question details
Hyperlinks added to Excel workbooks stored on SharePoint automatically convert from absolute SharePoint URLs to relative OneDrive links upon saving.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Adding web links to an Excel workbook hosted on a SharePoint server and saving the document.
- Observed behavior
- The absolute SharePoint links change to relative links, causing them to open as OneDrive URLs for all users accessing the affected workbooks.
Before proceeding, confirm whether this hyperlink conversion issue is isolated to a single Excel workbook or affects multiple users and files across your organization's Microsoft 365 environment.
Escalate to Your IT Department and Microsoft Support
Because this hyperlink routing issue typically affects all workbooks and users across the entire organization, escalating to IT for tenant-level investigation is the recommended approach.
When SharePoint URLs automatically route to OneDrive across an entire organization, the root cause usually lies within the Microsoft 365 tenant configuration or backend sync policies. Standard application-level troubleshooting may not permanently resolve this.
Identify and collect specific examples of Excel workbooks stored on SharePoint where the hyperlink changes occur.
Copy and save the original absolute SharePoint URL you intended to use, alongside the exact OneDrive URL it automatically changes to after saving.
Reach out to your organization's IT department or SharePoint administrator, providing them with the documented examples and affected user accounts.
Request your IT administrator to open an official Microsoft 365 support ticket so that Microsoft engineers can investigate the organization's tenant configuration.

Disable Automatic Updating of Links in Excel Web Options
Prevent Excel from automatically updating web paths on save, which can sometimes stop absolute URLs from converting to relative ones.
Try WPS Office for Stable Hyperlink Management
If Microsoft Excel's automatic link conversion disrupts your team's workflow, consider switching to WPS Office. It provides a lightweight, highly compatible alternative that respects your original document formatting and hyperlink structures without unwanted automated changes.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install and Launch: Run the installer, set up the software, and open WPS Spreadsheet.
- 3. Open your workbooks: Open your existing .xlsx workbooks directly in WPS to securely manage your data and web hyperlinks.

Frequently Asked Questions
Why do my absolute SharePoint links change to relative links in Excel?
Excel contains a built-in feature that automatically updates document links upon saving. When working within Microsoft 365 environments, this feature often attempts to optimize web paths by converting absolute SharePoint URLs into relative paths based on the file's current cloud sync location.
Does this link conversion issue affect all users viewing the SharePoint workbook?
Yes. Once the workbook is saved with the modified link, the file is updated on the SharePoint server. Anyone opening that workbook subsequently will be directed to the newly converted OneDrive link instead of the original absolute path.
Can I prevent Excel from changing URLs to OneDrive links permanently?
You can try disabling the 'Update links on save' feature located in Excel's Advanced Web Options. However, if your organization enforces strict tenant-level OneDrive/SharePoint sync policies, the issue may persist and require your IT administrator to intervene via Microsoft Support.
Will using a different office suite stop my links from converting?
Using an alternative office suite like WPS Office can prevent the application-level forced conversion of links upon saving. Keep in mind that cloud-level URL routing still depends on your organization's SharePoint server configurations.




