OneDrive File Issues

Fix Excel Files That Keep Asking to Save a Copy in OneDrive

Nimra MalikNimra Malik Nov 2, 2026 870 views

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.

How to Fix Excel Files That Always Ask to Save a Copy in OneDrive
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 you start

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.

Solution 1Recommended

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.

1
Open Excel Options

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.

2
Navigate to Save Settings

In the Excel Options dialog box, click on 'Save' in the left-hand pane.

3
Modify Default Save Location

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'.

4
Apply and Restart

Click 'OK' to apply the changes, then completely close and restart Excel.

Change the Default Save Location to Your Computer
AutoSave Behavior: Disabling the default OneDrive AutoSave will require you to save your documents manually using Ctrl+S or the disk icon.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and click 'Open' to locate and open your existing .xlsx files directly.
  3. 3. Save Without Interruptions: Edit and save your work locally or to the WPS Cloud without facing recurring 'Save a Copy' interruptions.
Fully compatible with Microsoft Excel (.xlsx, .xls) files.Free and lightweight alternative to Microsoft Office.Built-in WPS Cloud provides seamless and reliable automatic backups.Familiar tabbed user interface ensures an easy transition without learning curves.
microsoft office alternative - wps office

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.