How to Fix SharePoint Links Breaking When Copied from Excel to Outlook
Question details
SharePoint hyperlinks convert to relative paths and break when copied from an Excel spreadsheet into an Outlook email.
- Product
- Microsoft Excel, Outlook, SharePoint
- Device & OS
- not provided
- Scenario
- Copying and pasting SharePoint links from an Excel document to an Outlook email to share files with external recipients or other clients.
- Observed behavior
- The pasted links are converted into relative paths (e.g., ../../../../../:x/g/), which may work locally for the sender but fail to open for the email recipients.
Ensure you have the correct sharing permissions configured for the SharePoint file, and that external recipients are authorized to view the linked content before sending the email.
Disable Automatic Updating of Workbook Links in Trust Center
Modify Excel's Trust Center settings to prevent the application from automatically converting absolute SharePoint URLs into relative paths upon pasting.
By default, Excel sometimes attempts to optimize web paths by converting them into relative paths based on the workbook's current save location. Disabling this automatic update behavior forces Excel to preserve the complete, absolute URL.
Launch Microsoft Excel, click on 'File' in the top-left corner of the ribbon, and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, select 'Trust Center' from the left-hand pane, then click the 'Trust Center Settings...' button.
Navigate to 'External Content' or 'Workbook Links' in the left menu. Look for the setting regarding automatic updating of workbook links and disable it.
Click 'OK' to save your changes. You must now recreate or recopy the SharePoint link in your Excel workbook to ensure the absolute URL is captured, then paste it into Outlook.
Copy the Sharing Link Directly from SharePoint
Bypass Excel's link formatting entirely by generating and copying the sharing link directly from the SharePoint web interface.
Try WPS Office for Seamless Spreadsheet and File Management
Tired of dealing with broken links and complex Trust Center settings? WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office. It offers a familiar interface, seamless document editing, and excellent format compatibility without the hassle of unexpected link conversions.
- 1. Download the Installer: Visit the official WPS website and download the free WPS Office installation package.
- 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up the software on your device.
- 3. Open Your Workbooks: Launch WPS Spreadsheet and open your existing .xlsx files instantly without losing any formatting or data.
Frequently Asked Questions
Why do my SharePoint links turn into relative paths in Excel?
Excel has a built-in feature that attempts to optimize links by changing absolute URLs into relative paths based on the workbook's save location on a network or SharePoint drive. This optimization can cause the links to break when extracted or pasted into an external application like Outlook.
Do external users need special permissions to open SharePoint links?
Yes. Even if the hyperlink is formatted correctly with an absolute path, external recipients must be granted explicit access. The link must be generated with the 'Anyone with the link can view' permission, or the recipients must be added as guests in your SharePoint directory.
Will disabling automatic link updates affect my spreadsheet formulas?
Disabling the automatic updating of workbook links primarily affects how external data connections and hyperlinks are refreshed upon opening. If your workbook relies heavily on linked data from other files, you may need to manually update those external cell references via the Data tab.
