'%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 Fix Word and Excel Converting Relative Hyperlinks to Absolute Paths
Question details
The user needs to prevent Microsoft Office applications from automatically converting relative hyperlinks to absolute paths to maintain portable folder structures.
- Product
- Microsoft Word and Excel
- Device & OS
- not provided
- Scenario
- Creating linked manuals or documentation where linked files and folders need to be moved or renamed without breaking the connections.
- Observed behavior
- Relative links beginning with "..\" are automatically converted into absolute paths, preventing the links from working once the parent folders are moved or renamed.
Ensure you have a backup of your master document and all linked files in their original folder structures before modifying hyperlink bases or web options.
Disable 'Update Links on Save' in Web Options
Use this solution to stop Microsoft Office from automatically converting and updating your carefully placed relative hyperlinks when you save the document.
By default, Office may attempt to update links upon saving to ensure they remain functional based on its own path resolution. Disabling this feature forces the program to retain the exact path you entered.
Launch Word or Excel, open your document, and navigate to File > Options > Advanced.
Scroll down to the 'General' section and click on the 'Web Options' button.
In the Web Options dialog, go to the 'Files' tab, uncheck the box for 'Update links on save', and click OK to apply the changes.
Define a Hyperlink Base in Document Properties
Setting a specific hyperlink base forces the application to treat all inserted links as relative to the designated base path rather than defaulting to an absolute drive path.
Submit a Ticket to Microsoft 365 Business Support
If you are using a Microsoft 365 business license and the issue persists across new documents, it may be a known defect or recent update change that requires developer-level support.
Switch to WPS Office for Reliable File Management
If Microsoft Office updates are disrupting your workflow by breaking relative hyperlinks, try WPS Office. It provides a stable, highly compatible, and free environment that fully supports standard Office formats while respecting your original document structures.
- 1. Download WPS Office: Visit the official WPS website to download and install the free version of WPS Office.
- 2. Open your files: Launch the application and seamlessly open your existing Microsoft Office files.
- 3. Maintain your links: Continue editing your manuals and files knowing your relative hyperlink structures will be accurately preserved.
Frequently Asked Questions
What is the difference between an absolute and a relative hyperlink in Word or Excel?
An absolute hyperlink contains the full destination address (e.g., C:\Documents\Manuals\file.pdf). A relative hyperlink provides a path relative to the current document's location (e.g., ..\Manuals\file.pdf), making it essential for portable folders that may be moved to different drives or computers.
Why do my relative links break when I move my document folders?
If an application automatically converts your relative paths to absolute paths upon saving, moving the folders changes their actual drive location. The absolute path will then point to the old, non-existent location, breaking the connection.
How do I stop Microsoft Office from updating links on save?
You can disable this behavior by navigating to File > Options > Advanced. Scroll down to the General section, click on 'Web Options', select the 'Files' tab, and uncheck 'Update links on save'.
