Office Settings & Configuration

How to Stop Excel from Creating Extra Numbered File Copies

Algirdas Jasaitis Oct 12, 2026 869 views

Question details

The user needs to prevent Excel from automatically generating duplicate files with incrementing numbers in their filenames when saving or syncing.

How to Stop Excel from Creating Extra Numbered File Copies

Product: Microsoft Excel
Device & OS: not provided
Scenario: Managing spreadsheets and saving workbooks without cluttering the local folder or cloud directory with unwanted duplicate files.
Observed behavior: Excel automatically creates additional duplicate files with numbers appended to the filename upon saving, syncing, or editing.

Before you start

Ensure you have full administrative or edit access to the folder where your Excel files are saved. It is also recommended to temporarily pause cloud synchronization services like OneDrive while testing these settings.

Solution 1Recommended

Disable AutoRecover and Track Changes in Excel

Turn off built-in Excel features that automatically generate backup copies or version history files to prevent numbered duplicates.

Excel uses AutoRecover and Track Changes to protect data from accidental loss. However, these features can sometimes spawn numbered backup files in your working directory. Disabling them can quickly resolve the clutter.

Access Excel Save Options

Open your Excel workbook, click on 'File' in the top ribbon menu, and select 'Options'. In the Excel Options dialog box, click on the 'Save' tab on the left sidebar.

Disable AutoRecover

Uncheck the box that says 'Save AutoRecover information every X minutes' and ensure 'Keep the last autosaved version if I close without saving' is also unchecked. Click 'OK' to apply the changes.

Turn Off Track Changes

Navigate to the 'Review' tab on the main ribbon. If 'Track Changes' is active, click it and uncheck 'Highlight changes on screen' to disable the background version tracking.

Disable AutoRecover and Track Changes in Excel

Manual Saving Required: By disabling AutoRecover, Excel will no longer automatically save background copies in case of a crash. Remember to manually save your work frequently using the Ctrl+S shortcut.

Solution 2

Modify Cloud Sync and Versioning Settings

Resolve file conflicts caused by cloud synchronization tools like OneDrive creating alternate file versions.

Free Microsoft Office alternative

Try WPS Office for a Cleaner File Management Experience

If Microsoft Excel's background syncing and track changes continue to clutter your folders with numbered file copies, consider switching to WPS Office. It offers a straightforward, lightweight spreadsheet tool with highly customizable backup settings that keep your directories clean.

1. Download and Install WPS Office: Download WPS Office for free from the official website and install it on your computer.
2. Open Your Excel File: Launch WPS Spreadsheet and seamlessly open your existing .xlsx files without losing any data or formatting.
3. Configure Clean Backups: Go to Menu > Settings > Backup Setting to easily manage or disable local auto-backups, preventing any unwanted numbered file copies.

Avoid unexpected numbered duplicate files with transparent, easily manageable local backup settings.Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Lightweight installation that does not force intrusive background cloud syncing.Familiar tabbed user interface, ensuring a seamless migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel file save as a copy with a number?

This usually happens due to OneDrive sync conflicts, AutoRecover settings triggering a backup, Track Changes saving alternate versions, or an overly aggressive antivirus program locking the original file while saving.

Can third-party antivirus software cause duplicate numbered Excel files?

Yes. Some antivirus or automated backup programs might scan or lock the original file at the exact moment Excel is trying to overwrite it. To prevent data loss, Excel creates a numbered copy to successfully save your changes.

How do I stop OneDrive from making copies of my Excel files?

Open your OneDrive settings, navigate to the Sync or Office tab, and look for sync conflict settings. Change the default behavior to 'Let me choose to merge changes or keep both copies' rather than forcing an automatic duplicate.

Office App Problems