How to Fix Excel Changing Linked Workbook Paths After Moving Files
Question details
The user needs to understand why linked workbook paths change unexpectedly and how to fix broken external links after moving source files.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Moving a source workbook that contains linked charts or data between mapped drives, folders, or network servers.
- Observed behavior
- The linked path changes unexpectedly or breaks because Excel resolves the relative path differently based on the new file location.
Ensure you know the exact new folder path or mapped network drive location of the source workbook before attempting to update your external links.
Manually Update the External Link Source
The most reliable way to fix broken paths caused by moving files is to manually point Excel to the new source location using the Edit Links tool.
Excel often stores linked-file paths relative to the active workbook's location. When you move the source file or the destination file, this relative path calculation changes, which can lead to broken or altered links. By using the 'Edit Links' feature, you can quickly redefine the correct source path.
Go to the 'Data' tab on the Excel ribbon and click on 'Edit Links' located in the Queries & Connections group.
In the Edit Links dialog box, locate and select the linked source workbook that has the changed or broken path.
Click the 'Change Source' button on the right side of the dialog box.
Browse to the new mapped drive or server location, select the source workbook, and click 'OK' to update the path.

Keep Source and Destination Workbooks in the Same Folder
Prevent link path changes by organizing dependent workbooks in the same directory before moving them to a new drive.
Easily Manage External Workbook Links with WPS Spreadsheet
WPS Office offers robust tools for managing external data links, ensuring your linked charts and formulas remain intact even when migrating files across drives. It provides full compatibility with Microsoft Excel formats (.xlsx) and makes updating paths simple.
- 1. Open the Data Tab: Launch WPS Spreadsheet, open your workbook, and navigate to the 'Data' tab on the top menu ribbon.
- 2. Select Edit Links: Click on 'Edit Links' to view a list of all external references and connections within your current workbook.
- 3. Update the Path: Select the broken link from the list, choose 'Change Source', and browse to your source file's new location to restore the connection.

Frequently Asked Questions
Why does Excel use relative paths instead of absolute paths for external links?
Excel defaults to relative paths so that entire folders containing multiple linked workbooks can be moved to different drives or shared with other users without breaking the inter-file connections. However, moving only one of the linked files disrupts this relative relationship.
Can I force Excel to use absolute paths for external links?
Excel does not have a strict global toggle to always enforce absolute paths for local files. However, linking to files using a UNC path (e.g., \\servername\folder\file.xlsx) instead of a mapped drive letter often helps maintain a static, absolute reference regardless of how the destination file moves.
How do I find all the hidden external links in my workbook?
You can view managed external links by going to Data > Edit Links. To find links hidden within formulas, press Ctrl + F to open the Find dialog, enter the bracket character '[' (which Excel uses to denote external workbook references), and click 'Find All'.
Will updating the link source update my charts automatically?
Yes. Once you successfully update the source path via the 'Change Source' option in the Edit Links dialog, Excel immediately refreshes the data connection. Your linked charts and formulas will automatically reflect the data from the new location.




