Fix Excel Files That Keep Asking to Save a Copy in OneDrive
Question details
Users experience a recurring prompt in Excel to save a copy of their file when working on spreadsheets stored in a OneDrive folder.

- Product
- Excel 2016, OneDrive
- Device & OS
- not provided
- Scenario
- Saving an Excel workbook that is actively synced and stored within a OneDrive directory.
- Observed behavior
- Excel constantly prompts the user to 'Save a Copy' instead of saving changes to the original file, even though Word and PowerPoint function normally.
Before changing your settings, ensure that you have a local backup of the affected Excel file and check your system tray to verify that OneDrive is currently running and connected to the internet.
Change the Default Save Location to Your Computer
Adjusting Excel's default save settings prevents it from forcing a new copy into OneDrive when encountering automatic synchronization conflicts.
By default, Office 365 and Excel 2016 attempt to prioritize saving to the cloud. When a file is stored in a OneDrive folder and AutoSave is active, minor sync delays can trigger the 'Save a Copy' prompt. Forcing the default save location to your computer circumvents this conflict.
Open the affected file in Excel, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, click on 'Save' in the left-hand pane.
Check the box next to 'Save to Computer by default'. If applicable, uncheck the option for 'AutoSave OneDrive and SharePoint Online files by default on Excel'.
Click 'OK' to apply the changes, then completely close and restart Excel.

Verify File Properties and OneDrive Sync Status
Ensure the file isn't locked by another process or marked as read-only, which immediately forces Excel to generate a new copy.
Switch to WPS Office to Avoid OneDrive Sync Conflicts
If Excel continues to prompt you to save copies of your work, consider switching to WPS Office. It provides a stable, lightweight environment for spreadsheet editing with its own integrated cloud sync, eliminating common OneDrive conflicts.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and click 'Open' to locate and open your existing .xlsx files directly.
- 3. Save Without Interruptions: Edit and save your work locally or to the WPS Cloud without facing recurring 'Save a Copy' interruptions.

Frequently Asked Questions
Why does Excel keep asking me to save a copy instead of saving my original file?
This usually happens when there is a synchronization conflict with OneDrive, if the file is marked as read-only, or if Excel's AutoSave feature struggles to overwrite the cloud version simultaneously.
Will changing the default save location to my computer stop OneDrive backups?
Setting the default save location to your computer means new files will default to your local drive. However, if your local folders (like Documents or Desktop) are already set to sync with OneDrive, they will continue to back up normally.
How do I turn off AutoSave for a specific Excel file?
You can easily toggle off the AutoSave switch located at the top-left corner of the Excel window's title bar specifically for the individual workbook you are currently editing.
Does this 'Save a copy' issue affect Word or PowerPoint?
In this specific scenario, the issue typically isolates itself to Excel files. Word and PowerPoint files in the exact same OneDrive folder often continue to save and sync normally without prompting for a copy.




