SharePoint Document Issues

Create SharePoint-Based Excel Links Instead of Local OneDrive Paths

Algirdas JasaitisAlgirdas Jasaitis Nov 14, 2026 868 views

Question details

Create Excel workbook links that other users can access through SharePoint rather than a computer-specific OneDrive path.

Create SharePoint-Based Excel Links Instead of Local OneDrive Paths
Product
Microsoft Excel and SharePoint
Device & OS
not provided
Scenario
A user links Excel workbooks stored in a SharePoint library synchronized through OneDrive and shares the destination workbook with others.
Observed behavior
The links refer to local OneDrive paths, making access unreliable on other computers.
Before you start

Confirm that both workbooks are in the same SharePoint document library and that the intended users have permission to access them. Wait for OneDrive to finish synchronizing any changes before reopening or moving the files.

Solution 1Recommended

Recreate and verify workbook links from the SharePoint library

Use desktop Excel to recreate the links and check whether their sources resolve through SharePoint.

Opening both workbooks from SharePoint can help Excel identify their shared location, but it does not guarantee that every link will be saved as a SharePoint URL. Verify the saved source and test it from another computer.

1
Open both workbooks from SharePoint

In the SharePoint document library, locate the source and destination workbooks. For each file, select Open > Open in app to open it in desktop Excel.

2
Recreate the link

In the destination workbook, select a cell that needs data, type an equals sign, switch to the source workbook, and select the source cell. Press Enter to create the external reference. Repeat for the links you need to replace.

3
Check the source location

In the destination workbook, open Data > Workbook Links or Data > Edit Links, depending on your Excel version. Inspect the source location and confirm whether it points to SharePoint rather than a user-specific local path.

4
Save and allow synchronization

Save the destination workbook and the source workbook in Excel. If OneDrive is syncing the library, check its status icon and wait until synchronization is complete before moving either file.

5
Test from another computer

Have another authorized user open the destination workbook from the SharePoint library in desktop Excel and update its links when prompted. Confirm that the expected source data appears.

Recreate and verify workbook links from the SharePoint library
If the link still uses a local path: Reopen both files directly from the SharePoint library and check the link again. If the path remains local, the link may not be portable; test access with the library synchronized on the other user's computer. Avoid breaking existing links until you are ready to replace them, because breaking a link converts linked formulas to values.
Free Microsoft Office alternative

Work with Excel Files in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move everyday spreadsheet work. It does not fix how Microsoft Excel saves SharePoint workbook links.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLSX and XLS formatsReview spreadsheet formulas and linked data in your filesFree and lightweight for everyday office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel link show a local OneDrive path?

When a workbook is opened from a synchronized folder, Excel may identify the source using that computer's local path. Open both workbooks from the SharePoint library in desktop Excel, recreate the link, and check its source under Data > Workbook Links or Data > Edit Links.

Do other users need access to both workbooks?

Yes. Users who need to update the link must be able to access the source workbook as well as the destination workbook. Check their permissions in the SharePoint document library and test the link in desktop Excel.

Can I edit external workbook links in Excel for the web?

Excel for the web has limitations for external workbook links, and available features can vary. Use desktop Excel to recreate and inspect the links through Data > Workbook Links or Data > Edit Links.

What happens if I break an existing workbook link?

Using Break Link in Excel's link management tools converts formulas that depend on that link to their current values. Recreate the necessary formulas instead if you still need the data to update.