File Sharing Problems

How to Link Two Excel Workbooks on Different Computers in Real Time

Phi Hung Vo Oct 19, 2026 869 views

Question details

The user wants to link cells between two Excel workbooks opened independently on different computers, ensuring data synchronizes in real time.

How to Link Two Excel Workbooks on Different Computers in Real Time

Product: Microsoft Excel
Device & OS: not provided
Scenario: Collaborating on interconnected spreadsheets or sharing live data feeds across multiple computers simultaneously.
Observed behavior: External links fail to sync reliably in real time between independently opened files on separate computers, and Excel for the Web restricts opening workbooks with external data feeds.

Before you start

Ensure both computers are connected to the internet and have desktop access to the same shared cloud directory (such as OneDrive, Google Drive, or Dropbox) where the workbooks will be stored.

Solution 1Recommended

Link Workbooks via Cloud Storage and Paste Link

Store files in a shared cloud drive and use the Paste Special feature to create external links that update across computers.

For a basic workbook-to-workbook link, the most reliable method is to map the workbooks to a shared cloud folder. Please note that external links are not designed for split-second real-time streaming; users may need to refresh the destination workbook to fetch the latest changes saved by the other computer.

Save to a shared location

Save both the source workbook and the destination workbook into a shared cloud sync folder (e.g., OneDrive or Dropbox) accessible by both computers.

Open both workbooks

On one of the computers, open both the source and destination workbooks in the desktop Excel application to establish the initial link.

Copy the source data

Select the cells containing the data in the source workbook and press Ctrl+C to copy them.

Paste as a link

Switch to the destination workbook, right-click the target cell, select 'Paste Special', and click 'Paste Link' to establish the external reference.

Configure automatic updates

Go to Data > Edit Links, click 'Startup Prompt', and select 'Let users choose to display the alert or not' or 'Don't display the alert and update links' to ensure data fetches upon opening.

Link Workbooks via Cloud Storage and Paste Link

Web App Limitations: Workbooks containing complex external links or data feeds may not open directly in Excel for the Web. Users will need to click the option to open the file in the desktop application to update the linked cells.

Solution 2

Consolidate and Co-author for True Real-Time Sync

If real-time simultaneous data updates are required, consolidate your data into a single workbook and use Microsoft 365's Co-authoring feature.

Real-Time Spreadsheet Collaboration

Use WPS Office for Seamless Cloud Collaboration

WPS Office offers robust spreadsheet capabilities with built-in cloud sharing and real-time collaboration. It provides excellent compatibility with Microsoft Excel formats while offering a free, lightweight alternative for teams needing to link data, share files, and edit simultaneously across multiple devices.

1. Install WPS Office: Download and install WPS Office on both computers.
2. Save to WPS Cloud: Open your spreadsheet in WPS Spreadsheets and save it directly to your integrated WPS Cloud drive.
3. Share with collaborators: Click the 'Share' button at the top right of the application to generate an editing link and send it to the other user.
4. Collaborate in real time: Both users can open the cloud document simultaneously to view, edit, and update data in real time without dealing with broken external links.

Seamlessly view and edit Microsoft Excel (.xlsx, .xls) filesBuilt-in WPS Cloud for real-time synchronization across computersLightweight application that runs smoothly on older devicesFree alternative to costly office suite subscriptions

microsoft office alternative - wps office

Frequently Asked Questions

Why won't my Excel file with external links open in Excel for the Web?

Excel for the Web has limited support for calculating external data feeds and updating complex workbook links across separate files. You will typically receive an error prompt and must open the file in the desktop version of Excel to view and interact with the linked cells.

Can two people edit linked Excel workbooks at the exact same time?

While you can edit them simultaneously if stored on a network drive or cloud sync folder, external links between two separate workbooks do not stream data continuously in real time. To see the updated linked data, the destination workbook usually needs to be refreshed or reopened after the source workbook saves its changes.

What if I don't want to use Microsoft 365 cloud services for my files?

If Microsoft 365 is unavailable, you can map your workbooks to a shared local network drive (LAN), use third-party sync tools like Google Drive or Dropbox, or migrate your specific data workflows to a centralized web-based database or web application.

Document & File Issues