File Sharing Problems

How to Link Excel Workbooks Stored in OneDrive or SharePoint

Emma Brown Oct 8, 2026 870 views

Question details

The user needs to establish reliable data links between Excel workbooks hosted on OneDrive or SharePoint.

How to Link Excel Workbooks Stored in OneDrive or SharePoint

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating and maintaining data connections between multiple cloud-stored Excel workbooks.
Observed behavior: Workbook links function correctly when both Excel files are open, but the links fail to update or return errors when the source workbook is closed and lacks a local synced copy.

Before you start

Ensure you have full editing permissions for both the source and destination Excel files within your OneDrive or SharePoint environment before attempting to link them.

Solution 1Recommended

Use Native Workbook Links in Excel for the Web

Recommended for users working entirely within the browser, utilizing Excel for the web's built-in cloud linking features.

Microsoft Excel for the web natively supports linking to other cloud-stored workbooks. However, there are known limitations where links may fail to refresh if the source file is completely closed without a local desktop sync. Microsoft is currently investigating these background refresh limitations.

Open both workbooks in the browser

Navigate to your OneDrive or SharePoint folder and open both the source workbook and the destination workbook in separate browser tabs using Excel for the web.

Initiate the cell link

In your destination workbook, select the cell where you want the data to appear and type an equals sign (=).

Select the source data

Switch to the browser tab containing the source workbook, click the specific cell or range of cells you want to link, and press Enter. The data will now be linked.

Manage and refresh links

To check the connection status, go to the 'Data' tab in the ribbon and select 'Workbook Links'. Here you can manually refresh connections if the data fails to update.

Use Native Workbook Links in Excel for the Web

Cloud Linking Limitation: If links consistently fail when the source file is closed, you may need to keep both files open during updates or wait for Microsoft to release an update addressing this limitation.

Solution 2

Sync Files Locally via OneDrive Desktop App

Use this method to avoid closed-file link failures by relying on local desktop synchronization.

Free Microsoft Office alternative

Manage and Link Spreadsheets Locally with WPS Office

If you are frustrated by cloud linking limitations in Microsoft Excel, consider using WPS Office. It offers a lightweight, highly compatible alternative that handles local workbook linking seamlessly, completely free of charge.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite.
2. Open your spreadsheets: Launch WPS Spreadsheet and open your existing Excel workbooks directly.
3. Create stable links: Type '=' and click across your open workbooks to establish reliable standard links that update seamlessly on your local drive.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Reliable standard cell linking between local workbooks without cloud sync errors.Lightweight installation with fast performance for large datasets.Familiar spreadsheet interface that requires zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel workbook links break when the source file is closed in OneDrive?

Excel for the web currently has limitations regarding background data refreshes. When the source workbook is closed and only exists in the cloud (without a local synced copy), Excel often struggles to fetch the latest data, resulting in a broken link or #REF error.

Can I use Power Query to link closed Excel files in SharePoint?

Yes. Using Power Query ('Get Data' > 'From File' > 'From Workbook') is a more robust alternative for fetching data from closed workbooks in SharePoint. However, this often requires the desktop version of Excel to set up the initial connection.

Do local workbook links work differently than cloud links?

Yes. Local file paths allow the Excel desktop application to read data from a closed file directly from your hard drive. Cloud links rely on web protocols that currently require active sessions (open files) to authenticate and pull data reliably.

Document & File Issues