File Sharing Problems

How to Use the Same Excel External References on Two Computers

Adam DavisAdam Davis Nov 10, 2026 868 views

Question details

The user needs to maintain functional external references in Excel workbooks when sharing files across two computers with different folder paths.

How to Use the Same Excel External References on Two Computers
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Command Prompt

Press the Windows key, type 'cmd' into the search bar, right-click 'Command Prompt', and select 'Run as administrator'.

2
Create a Directory Junction (Optional)

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.

3
Map the Drive Letter

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.

4
Automate on Startup

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.

Map the Cloud Folder to a Matching Drive Letter
References Preserved: Excel will now read the mapped drive path natively, allowing your external formulas to calculate perfectly without macros or manual link updates.
Free Microsoft Office alternative

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. 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
  2. 2. Open Your Shared File: Navigate to your synced cloud folder and open your spreadsheet directly in WPS Spreadsheets.
  3. 3. Manage External Links: Go to the Data tab and use the 'Edit Links' option to effortlessly manage or update any external workbook references.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Accurately reads and calculates complex formulas and external references.Lightweight application that runs smoothly on Windows, Mac, and Linux.Free to download and use with a familiar, easy-to-navigate tabbed interface.
microsoft office alternative - wps office

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.