File Sharing Problems

Why Excel Uses Local SharePoint Sync Paths in Workbook Links

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

The user needs workbook links that other users can resolve when Excel files are stored in synchronized SharePoint or OneDrive folders.

Why Excel Uses Local SharePoint Sync Paths in Workbook Links
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the files from SharePoint

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.

2
Inspect the existing links

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.

3
Update the source if needed

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.

4
Test with another user

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.

Open the Workbooks Through SharePoint and Test Their Links
Check link support: Some workbook-link operations may work differently in Excel for the web. If a link cannot be updated there, test it in desktop Excel and verify the result with another user.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX filesWork with spreadsheet formulas in a familiar interfaceUse a lightweight suite for documents, spreadsheets, and presentationsMove existing Microsoft Office files into a familiar workflow
microsoft office alternative - wps office

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.