Create SharePoint-Based Excel Links Instead of Local OneDrive Paths
Question details
Create Excel workbook links that other users can access through SharePoint rather than a computer-specific OneDrive path.

- 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.
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.
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.
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.
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.
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.
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.
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.

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.

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.




