Prevent Excel SharePoint Links from Switching to Local OneDrive Paths
Question details
Keep linked Excel workbooks from switching between SharePoint Online and local OneDrive paths, particularly when working offline.

- Product
- Microsoft Excel, SharePoint Online, and OneDrive
- Device & OS
- not provided
- Scenario
- Excel workbooks are stored in SharePoint and synchronized locally through OneDrive.
- Observed behavior
- Linked-workbook paths can switch between online and local locations, causing broken links or delays when working offline.
Check that the SharePoint library is synced in OneDrive and identify both the workbook containing the links and its source workbooks. The Office sync setting described below may not be available in every OneDrive version or organization.
Disable OneDrive Office File Sync Integration
Use this setting, when available, to reduce Excel's reliance on Office-integrated syncing and work with locally synced files.
This changes how Office files are synchronized; it does not guarantee that Excel will never rewrite a workbook link. Real-time coauthoring and AutoSave may no longer be available for affected files.
Save and close the linked workbooks, then quit Excel completely to help release file locks.
Select the OneDrive cloud icon in the notification area, open Help & Settings, and select Settings.
Open the Office tab, clear “Use Office applications to sync Office files that I open,” and select OK. If the tab or checkbox is absent, check with your administrator before making other sync changes.
In the synced SharePoint folder, select the linked workbook and its source files, then choose “Always keep on this device” from the OneDrive context menu. Wait for OneDrive to finish downloading them.
Open the workbook from the local synced folder. In Excel, go to Data > Workbook Links or Data > Edit Links, depending on your version, and use Change Source if a link needs to point to the intended local source workbook.
Save and close the workbooks, then check the OneDrive cloud icon for sync completion. If uploads remain pending, quit Excel completely and check OneDrive again.

Work with Excel Workbooks in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel workbooks. Its format compatibility can make migration straightforward, although it does not change Excel or OneDrive sync settings.

Frequently Asked Questions
Why do my Excel links change between SharePoint and local paths?
Office and OneDrive integration can use online locations for synced files, while files opened from a synced folder also have local paths. Excel may update link references as workbooks are opened or saved in different contexts.
What happens if I turn off OneDrive Office file sync integration?
Clearing the Office sync checkbox changes how Office files are synchronized. Real-time coauthoring and AutoSave may no longer be available, and uploads may be delayed while Excel holds a file lock.
How can I make linked workbooks available offline?
In the synced SharePoint folder, select the workbook and its source files and choose “Always keep on this device.” Wait for the downloads to finish, then test the links in Excel while offline.
Where can I change a broken workbook link in Excel?
Open the workbook and go to Data > Workbook Links or Data > Edit Links, depending on your Excel version. Select the link and choose Change Source to locate the intended source workbook.
What if the Office sync checkbox is missing?
The setting may differ by OneDrive version or be managed by your organization. Check your OneDrive settings and contact your administrator rather than assuming the integration can be disabled.




