File Sharing Problems

Create Links Between Excel Workbooks on OneDrive or SharePoint

Ayan MasoodAyan Masood Nov 18, 2026 870 views

Question details

Create live references between cells in separate Excel workbooks instead of copying and pasting values.

Create Links Between Excel Workbooks on OneDrive or SharePoint
Product
Microsoft Excel, OneDrive, and SharePoint
Device & OS
not provided
Scenario
A user wants a destination workbook to reference data in a source workbook stored locally or in the cloud.
Observed behavior
The destination cell should display the source cell's value and update when the workbook link is refreshed.
Before you start

Identify the source cell and destination cell, and make sure you can access both workbooks. For cloud files, confirm that you have permission to open the source workbook in OneDrive or SharePoint.

Solution 1Recommended

Create a workbook link from OneDrive or SharePoint

Use this method when both workbooks are already stored in OneDrive or SharePoint.

1
Open both workbooks

In Excel desktop, use File > Open to open the source and destination workbooks from OneDrive or SharePoint.

2
Start the formula

In the destination workbook, select the cell that should display the linked value and type an equals sign (=).

3
Select the source cell

Switch to the source workbook, select the cell you want to reference, and press Enter. Excel creates the external reference for you.

4
Save and check the link

Save the destination workbook, change the source cell, and check that the destination value updates. If needed, use Data > Workbook Links or Data > Edit Links to review or refresh the link.

Create a workbook link from OneDrive or SharePoint
Keep the source accessible: The source workbook must remain accessible when Excel refreshes the link. Avoid renaming or moving the source file or worksheet without checking the link afterward.
Free Microsoft Office alternative

Work with Linked Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easier to move existing files into a new workflow. It does not repair Excel's OneDrive or SharePoint workbook links.

Work with spreadsheet formulas and referenced data in WPS SpreadsheetsOpen and edit Microsoft Excel formats, including XLSX and XLSUse a familiar interface for everyday spreadsheet tasksMove existing Office files into a lightweight, free workspace
microsoft office alternative - wps office

Frequently Asked Questions

Do I need to type the external reference manually?

No. Open both workbooks, type = in the destination cell, select the source cell in the other workbook, and press Enter. Excel creates the reference.

How do I refresh or inspect a workbook link?

In the destination workbook, open Data > Workbook Links or Data > Edit Links, depending on your Excel version. Use the available options to inspect or update the source.

What happens if I move the source workbook to OneDrive?

The existing link may still point to the old location or become unavailable. Open Data > Workbook Links or Data > Edit Links in the destination workbook and change the source to the cloud copy if needed.

Why is the linked value not updating?

Check that you can open the source workbook and that its file and worksheet names have not changed. Then review or refresh the link under Data > Workbook Links or Data > Edit Links.