Why Excel Uses Local SharePoint Sync Paths in Workbook Links
Question details
The user needs workbook links that other users can resolve when Excel files are stored in synchronized SharePoint or OneDrive folders.

- Product
- Microsoft Excel, SharePoint Online, and OneDrive
- Device & OS
- Windows
- Scenario
- Creating formulas between workbooks in synchronized SharePoint or OneDrive folders for use by multiple people.
- Observed behavior
- Excel formulas reference a local Windows sync path that other users cannot resolve.
Confirm that both workbooks have finished syncing and that each user has access to both the source and destination files. If the files are on different SharePoint sites, check permissions on both sites.
Open the Workbooks Through SharePoint and Test Their Links
Use the SharePoint locations rather than another user's local sync path, then verify that links work for the people who need them.
When you open files from a local OneDrive sync folder, Excel may create links using the local Windows path. OneDrive still syncs the files to SharePoint, but that local path may not exist on another user's computer.
Link behavior can vary by Excel version, how the files are opened, and whether the workbooks are on different sites. Opening files through SharePoint does not guarantee that every link will resolve.
In SharePoint, navigate to each workbook and use Open to open it in Excel. You can also test the files in Excel for the web.
In desktop Excel, open the destination workbook and go to Data > Workbook Links or Data > Edit Links, depending on your version. Select a link to inspect its source.
In Workbook Links or Edit Links, choose Change source if available and select the source workbook from its SharePoint or OneDrive location. Save the destination workbook.
Close and reopen the destination workbook from SharePoint, then ask another authorized user to open it and refresh the links. If the source is on another site, confirm that the user can open it there too.

Use a Shared Network Location for Both Workbooks
Use a common network path when everyone who needs the links can access the same file share.
Work With Excel Files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for Microsoft Office formats, making it easy to move existing files into your workflow. It does not repair Microsoft Excel or SharePoint link behavior.

Frequently Asked Questions
Why does Excel show a Windows path instead of a SharePoint URL?
When a workbook is opened from a local OneDrive or SharePoint sync folder, Excel may use that local path when creating a link. OneDrive continues to sync the files with SharePoint.
Where can I see or change a workbook link in Excel?
In desktop Excel, open the destination workbook and go to Data > Workbook Links or Data > Edit Links. Select the source and use Change source if that option is available.
Will opening both files in Excel for the web fix the links?
It can help you test access through SharePoint, but it does not guarantee that every workbook link will work. Open both files from SharePoint and verify the destination workbook with an authorized user.
What if the source workbook is on another SharePoint site?
Make sure each user can open both the destination workbook and the source workbook on the other site. Then refresh the link in the destination workbook and check whether it resolves.
Can I use a network share instead of a local sync path?
Yes, if all users can access the same network share. Store the workbooks there, update the source through Data > Workbook Links or Edit Links, and test the link from another user's account.




