How to Use the Same Excel External References on Two Computers
Question details
The user needs to maintain functional external references in Excel workbooks when sharing files across two computers with different folder paths.

- Product
- Excel
- Device & OS
- Windows
- Scenario
- Working on shared Excel files containing external links across multiple devices synced via cloud storage like ownCloud.
- Observed behavior
- Formulas with external references break because the local drive letters or folder paths on the second computer do not match the original file locations.
Ensure all your linked Excel workbooks are fully synchronized via your cloud storage provider to your local machine before attempting to remap paths or open the files.
Map the Cloud Folder to a Matching Drive Letter
Use the Windows 'subst' command or directory junctions to trick the system into treating your local cloud folder as the original drive letter.
By mapping the local synced folder to the exact same drive letter used on the original computer (e.g., the H: drive), Excel will automatically locate the external references without needing manual formula updates.
Press the Windows key, type 'cmd' into the search bar, right-click 'Command Prompt', and select 'Run as administrator'.
If you need to mirror a specific folder structure, use the mklink command. Type: mklink /J "C:\Your\Target\Folder" "C:\Path\To\ownCloud\Folder" and press Enter.
Use the subst command to assign the required drive letter (e.g., H:) to your synced folder. Type: subst H: "C:\Path\To\ownCloud\Folder" and press Enter.
Since the 'subst' command resets after a reboot, open Notepad, paste your subst command, and save the file as 'mapdrive.bat'. Move this file into your Windows Startup folder (Win + R, type 'shell:startup') to recreate the mapping automatically at login.

Store Linked Workbooks in the Same Folder
Keep the source and destination workbooks in the exact same directory to force Excel to use relative paths.
Try WPS Office for Seamless Spreadsheet Management
Handling complex external references and shared workbooks is easier with a lightweight, highly compatible office suite. WPS Office provides full compatibility with Microsoft Excel formats, allowing you to manage synced data seamlessly across multiple devices—completely free.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
- 2. Open Your Shared File: Navigate to your synced cloud folder and open your spreadsheet directly in WPS Spreadsheets.
- 3. Manage External Links: Go to the Data tab and use the 'Edit Links' option to effortlessly manage or update any external workbook references.

Frequently Asked Questions
Why do my Excel external links break when moving files to another computer?
When external links are created across different folders or drives, Excel often saves them as absolute paths (e.g., H:\Data\file.xlsx). If the second computer does not have an identical H: drive or folder structure, Excel cannot find the source file, resulting in broken links.
How do I fix the 'subst' mapped drive disappearing after restarting Windows?
The 'subst' command creates a temporary virtual drive that clears upon reboot. To make it permanent, save your subst command in a plain text file, rename the extension to .bat, and place it in the Windows Startup folder by typing 'shell:startup' in the Windows Run dialog.
Does mapping a cloud folder to a drive letter consume extra hard drive space?
No. The 'subst' command and directory junctions (mklink) only create virtual shortcuts to your existing files. They do not duplicate the data or take up additional storage space.
Can I use OneDrive or Google Drive instead of ownCloud for this method?
Yes, this path-mapping method works for any cloud synchronization service. Simply point the 'subst' or 'mklink' commands to your local OneDrive, Google Drive, or Dropbox sync folder path.




