OneDrive File Issues

Stop OneDrive from Synchronizing a Read-Only SharePoint File in Excel

Nimra MalikNimra Malik Nov 4, 2026 869 views

Question details

The user needs to prevent OneDrive from syncing a read-only SharePoint workbook that is being used as a data source for another Excel file.

How to Stop OneDrive from Synchronizing a Read-Only SharePoint File
Product
Microsoft Excel, OneDrive, SharePoint
Device & OS
not provided
Scenario
A user links a target Excel workbook to a synchronized SharePoint file to read data.
Observed behavior
The local copy of the read-only SharePoint file appears modified because Excel downloads it locally to extract data, which triggers OneDrive's bidirectional sync.
Before you start

Make sure you have a stable network connection to access your SharePoint files online and that all your current workbooks are backed up before altering any data connections.

Solution 1Recommended

Use Direct SharePoint File Path and Stop Local Sync

Update the target workbook to pull data directly from the SharePoint URL, eliminating the need to sync the source file locally through OneDrive.

Since OneDrive operates strictly as a two-way synchronization tool, it cannot be forced into a one-way sync. To resolve the false modification triggers on read-only files, you must bypass the local OneDrive sync folder entirely.

1
Copy the Direct File Path

Open the source SharePoint file in the Excel desktop application. Go to 'File' > 'Info' and click on 'Copy Path' to copy the direct URL. Note: Do not use a standard 'Share' link.

2
Update the Data Source

Open your target Excel workbook that requires the data. Navigate to the 'Data' tab, open your queries or data connections (or Edit Links), and replace the local file path with the copied SharePoint URL.

3
Stop OneDrive Synchronization

Click the OneDrive cloud icon in your system tray, go to 'Settings' (the gear icon), select the 'Account' tab, and click 'Stop sync' next to the SharePoint folder containing the source file.

Successful Disconnection: Your target workbook will now read data directly from the cloud without relying on the local OneDrive folder, preventing accidental sync conflicts and modification flags.
Free Microsoft Office alternative

Switch to WPS Office for a Streamlined Experience

Dealing with complex OneDrive and SharePoint sync limitations can disrupt your workflow. WPS Office offers a free, highly compatible alternative with its own robust and straightforward cloud synchronization system.

  1. 1. Download and Install: Visit the WPS Office website to download the free installer for your operating system.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly without any formatting loss.
  3. 3. Save to WPS Cloud: Use the integrated WPS Cloud to safely store and sync your files across all your devices effortlessly.
Fully compatible with Microsoft Excel (.xlsx) and other Office formats.Built-in WPS Cloud provides straightforward, reliable file synchronization.Lightweight software that launches quickly and consumes minimal system resources.Free to download with an intuitive, familiar tabbed interface for seamless migration.
QA img-9

Frequently Asked Questions

Can I configure OneDrive for one-way synchronization?

No, OneDrive is strictly a two-way synchronization service. Any changes made to a file locally will automatically attempt to sync back to the cloud, and vice versa.

Why does my read-only file show as modified on my local computer?

When an Excel workbook pulls data from a cloud-stored source file, Excel temporarily downloads or accesses the file locally. This background action can cause the file's metadata to change, which OneDrive detects as a modification even if you did not manually edit the data.

Is a SharePoint sharing link the same as the direct file path?

No. A standard sharing link often redirects through a web viewer or enforces specific browser permissions, which can break Excel data connections. Always use 'File > Info > Copy Path' within the Excel desktop app to get the true direct file URL for data queries.