OneDrive File Issues

Why Excel AutoSave Creates a OneDrive Copy and How to Fix It

Adam Davis Sep 28, 2026 869 views

Question details

The user wants to understand why turning on Excel's AutoSave feature for a local file automatically uploads a copy to OneDrive and creates a duplicate file.

Why Excel AutoSave Creates a OneDrive Copy

Product: Microsoft Excel
Device & OS: not provided
Scenario: Enabling the AutoSave toggle in Excel while working on a local spreadsheet.
Observed behavior: Excel uploads a copy of the file to OneDrive and saves subsequent changes to a new file with a duplicated name, such as filename (1).

Before you start

Ensure that you have an active internet connection and that the Microsoft OneDrive desktop application is installed, running, and logged into your Microsoft account.

Solution 1Recommended

Save the File Directly to a OneDrive Synced Folder

AutoSave only functions for files natively stored in OneDrive or SharePoint. Moving the file to a synced folder prevents Excel from generating duplicate copies.

By design, the AutoSave feature in Microsoft 365 requires the file to reside on a cloud server to track real-time changes. When you enable it for a local file, Excel is forced to create a cloud copy to avoid overwriting your local data, which results in the filename (1) duplication.

Close the current Excel file

Save your work and close the Excel file that is currently creating the duplicate.

Locate your local OneDrive folder

Open File Explorer and navigate to your local OneDrive directory, typically located at C:\Users\[YourUsername]\OneDrive.

Move the original file

Drag and drop or copy your original Excel file into the OneDrive folder (e.g., inside the Documents subfolder).

Reopen the file

Open the file directly from the OneDrive folder. The AutoSave toggle in the top-left corner should now be enabled automatically without creating a new copy.

Save the File Directly to a OneDrive Synced Folder

AutoRecover vs. AutoSave: For files saved outside of OneDrive, Excel uses AutoRecover, which saves temporary backup files every few minutes but does not continuously sync live changes.

Solution 2

Reset the OneDrive Desktop App

If your file is already in a OneDrive folder but duplicates are still being created, your OneDrive sync cache might be malfunctioning and requires a reset.

Free Microsoft Office alternative

Avoid Excel AutoSave Quirks with WPS Office

If you are tired of Microsoft Excel creating duplicate files in OneDrive just to use auto-save features, consider switching to WPS Office. It offers a robust local saving experience alongside flexible cloud backup options, without forcing unwanted file duplications.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
2. Install and Launch: Run the installer and follow the on-screen instructions, then open WPS Spreadsheets.
3. Open Your Excel Files: Open your existing .xlsx files directly. You can configure local Auto-Backup in the Settings without being forced to use OneDrive.

Fully compatible with Microsoft Excel (.xlsx, .xls) formatsFlexible Auto-Backup settings for both local and cloud storageFree to use with a familiar, easy-to-navigate interfaceLightweight and runs smoothly without mandatory cloud synchronization

Frequently Asked Questions

Why does Excel force me to save to OneDrive to use AutoSave?

Microsoft designed the AutoSave feature to rely on the real-time collaboration and version history capabilities provided exclusively by OneDrive and SharePoint cloud servers. It cannot continuously sync live changes to a purely local hard drive.

Can I use AutoSave without OneDrive?

No, the toggle switch for AutoSave in Microsoft 365 is exclusively for cloud-stored files. However, for local files, Excel uses AutoRecover, which saves recovery information at set intervals (e.g., every 10 minutes) but does not automatically save your live document.

How do I stop Excel from adding (1) to my file names?

To prevent this, do not manually toggle AutoSave on a local file. Instead, manually move your file into your OneDrive synced folder first, then open it from there. AutoSave will turn on automatically without creating a duplicate file.

Document & File Issues