'%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)
How to Preserve Full SharePoint HTTPS Links in Excel
Question details
The user wants to prevent Excel from automatically changing long SharePoint HTTPS URLs into relative local file paths, which causes the links to break when copied and pasted into other applications like Word or OneNote.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Inserting absolute SharePoint URLs into a spreadsheet and needing them to remain as standard web links rather than converting to local sync paths.
- Observed behavior
- Excel automatically converts long absolute SharePoint URLs into relative references, making them appear and function as local file paths when exported or copied to other apps.
Ensure your Excel workbook is saved before modifying global hyperlink settings, and have the original SharePoint HTTPS URLs ready to verify if the changes take effect correctly.
Disable Automatic Link Updating and AutoFormat Settings
Adjusting Excel's global Web Options and AutoCorrect settings prevents the application from automatically converting absolute internet paths into relative local paths.
Excel has built-in features that attempt to keep local file references intact by updating links on save and auto-formatting network paths. Disabling these options forces Excel to leave your exact SharePoint HTTPS URLs exactly as you pasted them.
In Excel, click on 'File' in the top-left corner and select 'Options'. In the Excel Options dialog box, click on 'Advanced' in the left pane, scroll down to the General section, and click the 'Web Options...' button.
In the Web Options window, navigate to the 'Files' tab. Locate the checkbox for 'Update links on save' and uncheck it. Click 'OK' to close the Web Options dialog.
Still within the Excel Options dialog, click on 'Proofing' in the left pane. Click the 'AutoCorrect Options...' button at the top of the menu.
Go to the 'AutoFormat as You Type' tab. Uncheck the option that says 'Internet and network paths with hyperlinks'. Click 'OK' on both dialog boxes to apply all changes.
Use the HYPERLINK Function to Force Absolute URLs
If changing global Excel settings is not viable, wrapping the URL in the HYPERLINK formula ensures Excel treats it strictly as a web address.
Experience Hassle-Free Spreadsheet Management with WPS Office
Tired of Excel automatically changing your URLs into local file paths? WPS Office offers a free, lightweight alternative to Microsoft Office. Enjoy seamless format compatibility, a familiar interface, and straightforward hyperlink management without unexpected auto-formatting disruptions.
- 1. Download and Install: Visit the official WPS website to download the free suite and follow the simple installation instructions.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xls files seamlessly.
- 3. Manage Hyperlinks with Ease: Add or edit your HTTPS URLs in WPS Spreadsheet, which respects your absolute link formats without unwanted local path conversions.
Frequently Asked Questions
Why does Excel change my SharePoint links to local paths?
Excel uses a built-in feature to update links on save. If it detects the file is synced locally via OneDrive or SharePoint, it often converts absolute URLs into relative references. This is intended to keep links intact when entire folders are moved, but it breaks the links when copying them individually to other apps.
Will using the HYPERLINK function fix existing broken links in my spreadsheet?
No, the HYPERLINK function will only prevent future links from breaking. For existing links that have already been converted to local file paths, you will need to manually edit them or recreate them using the exact SharePoint HTTPS address.
Does copying an Excel link to Word or OneNote always break it?
It only breaks if Excel has already converted the hyperlink to a local file path (e.g., C:\Users\Name\...). Disabling the 'Update links on save' setting ensures the absolute HTTPS path is copied to your clipboard, allowing it to paste and function correctly in Word or OneNote.
