How to Stop Excel from Creating Duplicate Files with 'Copy' in the Name
Question details
The user experiences an issue where a duplicate workbook is automatically generated with '(Copy)' appended to the filename after closing and reopening the original file.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Closing and reopening a shared or locally saved Excel workbook.
- Observed behavior
- A second workbook appears in the same directory with the exact same name but with '(Copy)' added at the end of the filename.
Make sure that all instances of Excel are completely closed in your Task Manager before attempting to repair files or change system settings.
Review and Adjust AutoRecover Settings
Improper AutoRecover settings can cause Excel to create unwanted copies. Adjusting these settings often resolves the duplication issue.
Excel's built-in AutoRecover feature is designed to prevent data loss, but aggressive saving intervals or unexpected application closures can cause it to generate a backup file labeled as a copy.
Launch Microsoft Excel, click on the 'File' menu in the top-left corner, and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, click on the 'Save' tab located in the left-hand panel.
Uncheck the box that says 'Keep the last AutoRecovered version if I close without saving'. You can also temporarily increase the time interval for 'Save AutoRecover information every X minutes' to see if the issue stops.
Click 'OK' to save your changes, then restart Excel and test whether the duplicate file is still being created.
Use the Open and Repair Tool
If the original workbook is corrupted, Excel might struggle to save it properly, resulting in a duplicate copy being forced into the directory.
Prevent Simultaneous Network Editing Conflicts
If the file is hosted on a network or cloud drive, multiple users or syncing tools accessing it at once can trigger Excel to save a copy to prevent overwriting data.
Try WPS Office to Avoid Excel File Syncing and Duplicate Errors
Tired of dealing with unexpected duplicate files, syncing errors, and file corruption in Microsoft Excel? WPS Office is a lightweight, highly compatible alternative that offers seamless spreadsheet editing without the hassle. It perfectly supports all Microsoft Office file formats, ensuring your data remains intact and accurately formatted.
- 1. Download and Install: Visit the official WPS website to download the free WPS Office suite for your PC or Mac.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx files directly without any conversion.
- 3. Edit and Save Seamlessly: Enjoy smooth editing and save your progress securely without worrying about unwanted duplicate copies being generated.
Frequently Asked Questions
Can deleting Excel temporary files stop the duplicate file issue?
Yes, lingering temporary files can sometimes confuse Excel's saving and overwriting process. You can navigate to your system's temp folder (%temp% in the Windows Run dialog) and clear it out. Always ensure Excel is completely closed before deleting these files to avoid application errors.
Why does the duplicate file only appear on my network drive?
Network drives can experience slight delays or locking mechanisms when multiple users or syncing clients access the file simultaneously. Excel creates the '(Copy)' file as a safeguard to ensure your latest changes aren't lost during these server-side conflicts.
Is it safe to delete the file marked as '(Copy)'?
Yes, as long as you have opened the original file and verified that all your recent edits and data are successfully saved in it. If the original is missing data, open the '(Copy)' file, save it under a new master name, and then you can safely delete the older files.
Does the AutoSave feature on OneDrive cause this duplicate behavior?
Occasionally, rapid AutoSave intervals combined with minor OneDrive syncing interruptions can cause a version conflict, resulting in a duplicate copy being created. Pausing OneDrive syncing temporarily while editing large files can help you identify if this is the root cause.
