Create Links Between Excel Workbooks on OneDrive or SharePoint
Question details
Create live references between cells in separate Excel workbooks instead of copying and pasting values.

- 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.
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.
Create a workbook link from OneDrive or SharePoint
Use this method when both workbooks are already stored in OneDrive or SharePoint.
In Excel desktop, use File > Open to open the source and destination workbooks from OneDrive or SharePoint.
In the destination workbook, select the cell that should display the linked value and type an equals sign (=).
Switch to the source workbook, select the cell you want to reference, and press Enter. Excel creates the external reference for you.
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.

Test a local workbook link before moving files to the cloud
Use a simple local test if you are new to external references, then check the link after moving the files.
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.

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.




