How to Fix Excel Workbook Links Losing Network Path
Question details
Users need to resolve an issue where external links in shared workbooks point to incorrect locations because network paths are being altered or lost.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening and updating linked workbooks stored across an organization's SMB network shares.
- Observed behavior
- External links lose part of their network path, often changing from mapped-drive paths to incomplete UNC paths, causing data update failures.
Ensure you are actively connected to your organization's network and have the exact mapped-drive letters and UNC paths available for reference.
Standardize Network Paths and Verify Permissions
Identify discrepancies between mapped-drive and UNC network paths to ensure all users access the linked workbooks using a consistent method.
Microsoft 365 updates can sometimes expose differences in how network paths are handled. When users open files via a server share instead of a mapped drive, links may automatically convert to UNC paths.
To prevent links from breaking, all users collaborating on the workbooks should map their network drives consistently and possess adequate folder permissions.
Open the affected workbook, navigate to the 'Data' tab on the ribbon, and click on 'Edit Links' to review the current source paths of your external links.
Test the workbooks directly from their SMB network shares. Check if the link changes from a mapped-drive path (e.g., Z:\Folder\file.xlsx) to a UNC path (e.g., \\Server\Folder\file.xlsx).
Ensure that all users opening the files have consistent read and write permissions for the specific folders where the source spreadsheets are stored.
If a link is broken due to a missing folder in the UNC path, select the broken link in the 'Edit Links' dialog, click 'Change Source', and manually reselect the correct source file.

Try WPS Office for Stable Spreadsheet Management
If Microsoft 365 updates continue to disrupt your network link paths, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with reliable external link management for your shared network folders.
- 1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
- 2. Open Your Network File: Launch WPS Spreadsheet and navigate to your SMB network share or mapped drive to open your existing workbooks.
- 3. Manage Data Links: Go to the 'Data' tab and use the 'Edit Links' feature to seamlessly manage and update your external file references.

Frequently Asked Questions
Why do my Excel links change to UNC paths automatically?
When workbooks are accessed through a server share rather than a local mapped drive, the application often converts the mapped-drive letter (like Z:\) into its absolute UNC path (like \\Server\Share\) to ensure other users on the network can locate the file.
How do I fix a broken external link in my workbook?
Go to the 'Data' tab and select 'Edit Links'. Select the broken link from the list, click 'Change Source', and navigate to the correct network folder to re-establish the connection.
Can missing folder permissions cause external links to fail?
Yes. If a user does not have read access to the specific network folder where the linked source workbook is stored, the link will fail to update and will display as broken when they open the destination workbook.




