File Corruption & Recovery

Fix Excel Creating Multiple Recovery Files After Restart

Muhammad Talha Sep 28, 2026 868 views

Question details

Excel opens multiple recovery copies of the same workbook and fails to automatically reopen all the files that were active before frequent system restarts.

How to Fix Excel Creating Multiple Recovery Files After a Restart

Product: Microsoft Excel
Device & OS: not provided
Scenario: Recovering Excel files after an unexpected shutdown or frequent computer restarts.
Observed behavior: Excel generates multiple duplicate recovery files for the same workbook and does not restore the previous session's open files upon launch.

Before you start

Before deleting any recovery files from your system, ensure you have located, opened, and safely saved the most recent version of your workbook to a secure local folder.

Solution 1Recommended

Review Document Recovery and Clear Temporary AutoRecover Files

Safely identify which recovery files contain your latest work, save them, and clear the remaining temporary files to stop Excel from repeatedly loading them.

When your computer restarts unexpectedly, Excel may not have the opportunity to close properly. As a result, it retains temporary AutoRecover files. If this happens frequently, these files can stack up, causing Excel to show multiple recovery copies of the same document.

To resolve this, you must manually save the versions you wish to keep and clear out the residual system files.

Open the Document Recovery Pane

Launch Microsoft Excel. If the Document Recovery pane appears on the left side of the screen, review the list of recovered files. Pay close attention to the timestamp on each file to identify the most recent and complete version.

Save the required workbook versions

Click the drop-down arrow next to the file version you want to keep and select 'Save As'. Save the workbook to a secure location on your local drive or cloud storage.

Locate the Excel recovery folder

Check the folder path indicated in the recovery prompt or navigate to the default AutoRecover location. On Windows, this is typically found at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\.

Remove unnecessary temporary files

Once you have safely saved your required workbooks, close Excel and delete the remaining temporary files or folders in the AutoRecover directory. This prevents Excel from continually trying to load outdated recovery files upon restart.

Review Document Recovery and Clear Temporary AutoRecover Files

Preventing Future Occurrences: To minimize data loss, try to manually save your work (Ctrl + S) frequently. You can also adjust the AutoRecover save interval in Excel by going to File > Options > Save.

Free Microsoft Office alternative

Try WPS Office for Reliable File Management and Backup

If you frequently experience unexpected restarts or Excel crashes, consider switching to WPS Office. It provides a stable, lightweight environment with a highly intuitive built-in file backup system to ensure your data is safe without generating confusing duplicate recovery files.

1. Download and Install WPS Office: Visit the official WPS website to download and install the free WPS Office suite for your device.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly without any data or formatting loss.
3. Enable Local Auto-Backup: Go to Menu > Settings > Backup Settings to configure an organized, reliable auto-backup directory that protects your work from unexpected restarts.

Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Lightweight software architecture that runs smoothly, reducing the risk of system overload and crashes.Robust Auto-Backup feature ensures secure, organized, and easy-to-find file recovery.Familiar tabbed user interface makes switching from Microsoft Office easy and seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Can I force Excel to automatically reopen all files I had open before a restart?

Excel does not natively guarantee the automatic restoration of an entire multi-window session after a forced or unexpected computer restart. You will generally need to rely on the Document Recovery pane to reopen unsaved files individually.

Where are Excel AutoRecover files saved by default?

By default on Windows systems, Excel saves AutoRecover files in C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. You can change this location by navigating to File > Options > Save and modifying the 'AutoRecover file location' path.

Why do multiple copies of the exact same workbook appear in Document Recovery?

This occurs when a workbook is caught in multiple unexpected shutdowns or crashes over time without being properly saved and closed. Excel generates a new temporary recovery file for each interrupted session, leading to duplicates.

How do I stop the Document Recovery pane from appearing every time I open Excel?

The pane will stop appearing once all recovered files have been either opened and saved, or explicitly removed from the list. You can click 'Close' on the Document Recovery pane and select the prompt's option to permanently remove the files if you are certain you no longer need them.

Document & File Issues