How to Stop Excel from Rewriting SharePoint Links for External Users
Question details
Users need to stop Excel from converting absolute SharePoint sharing URLs into relative or compressed links so external users can access them without errors.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Sharing Excel workbooks containing embedded SharePoint file links with external clients or partners who do not have organizational accounts.
- Observed behavior
- Excel automatically converts the fully copied absolute SharePoint sharing URLs into relative links, which work for signed-in employees but fail for external users.
Ensure that your SharePoint administrator allows external sharing and that the files you are linking to have been explicitly shared using the 'Anyone with the link' setting.
Adjust Web Options and Verify Link Configurations
Prevent Excel desktop from updating links on save and verify that the correct SharePoint permissions are applied for external access.
By default, Excel desktop attempts to maintain link paths by converting absolute URLs to relative URLs when saving files to web servers or SharePoint. Disabling this feature and testing with Excel for the web can resolve access failures for external users.
Open the Excel desktop application. Navigate to File > Options > Advanced. Scroll down to the General section and click the 'Web Options' button. Navigate to the Files tab and uncheck the box for 'Update links on save', then click OK.
To prevent unexpected desktop application formatting, open your workbook directly in Excel for the web. Copy your absolute SharePoint links and paste them into the web version of the workbook, as it generally does not alter URL structures.
Go to the SharePoint library where the linked files reside. Click the Share icon next to the file, select the gear icon for Link settings, and choose 'Anyone with the link'. Copy this specific URL to paste into your Excel file.
Create a completely new workbook in a different SharePoint library. Paste the external sharing links there and try opening them in an incognito browser window to simulate an external user experience without cached credentials.
Try WPS Office for Hassle-Free Spreadsheet Management
If Excel's automatic link formatting continues to disrupt your external sharing workflows, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment that gives you full control over your data without unexpected background alterations.
- 1. Download and Install WPS Office: Visit the official WPS Office website and download the free version for your operating system.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and directly open your existing .xlsx file without worrying about format loss.
- 3. Insert Links Confidently: Paste your SharePoint sharing URLs into the cells. WPS Office will preserve the exact text and hyperlink address you input.
Frequently Asked Questions
Why does Excel change my absolute SharePoint URLs to relative links?
Excel is designed to automatically convert absolute URLs into relative paths when saving to locations like SharePoint or OneDrive. This is intended to keep links functional if the entire folder structure is moved, but it breaks external sharing because outside users do not have permission to access the root relative path.
How do I check if my SharePoint link is forcing organizational sign-in?
Copy the sharing link from SharePoint and paste it into the address bar of a private or incognito browsing window. If the page prompts you for a Microsoft 365 login, the link is restricted to your organization. You must change the sharing setting to 'Anyone with the link can view'.
Will disabling 'Update links on save' affect other workbooks?
The 'Update links on save' setting in Web Options is typically an application-level preference in Excel desktop. Changing it will affect how Excel handles hyperlinks upon saving for other workbooks on that specific device, but it helps ensure your URLs remain exactly as you typed them.
