Stop OneDrive from Synchronizing a Read-Only SharePoint File in Excel
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.

- 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.
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.
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.
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.
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.
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.
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. Download and Install: Visit the WPS Office website to download the free installer for your operating system.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly without any formatting loss.
- 3. Save to WPS Cloud: Use the integrated WPS Cloud to safely store and sync your files across all your devices effortlessly.

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.




