OneDrive File Issues

Prevent Excel SharePoint Links from Switching to Local OneDrive Paths

Natalie TaylorNatalie Taylor Nov 18, 2026 869 views

Question details

Keep linked Excel workbooks from switching between SharePoint Online and local OneDrive paths, particularly when working offline.

Prevent Excel SharePoint Links from Switching to Local OneDrive Paths
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.
Before you start

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.

Solution 1Recommended

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.

1
Close Excel

Save and close the linked workbooks, then quit Excel completely to help release file locks.

2
Open OneDrive settings

Select the OneDrive cloud icon in the notification area, open Help & Settings, and select Settings.

3
Turn off Office integration

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.

4
Prepare offline copies

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.

5
Check the workbook links

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.

6
Confirm synchronization

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.

Disable OneDrive Office File Sync Integration
Check links after changing sync behavior: Keep the linked files in a consistent folder structure and test the links offline. Avoid deleting synced local copies as a routine reset: deletions can also synchronize to SharePoint.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS files.Work with spreadsheets locally when offline.Use a familiar spreadsheet interface for an easier transition from Microsoft Office.Install a lightweight office suite with a free version.
microsoft office alternative - wps office

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.