Recover Unsaved Excel Files After an Unexpected Shutdown

Problem Overview

Recover an unsaved Excel workbook after a shutdown from Document Recovery, Recover Unsaved Workbooks, or the configured AutoRecover folder.

Quick Answer

Recover an unsaved Excel workbook after a shutdown from Document Recovery, Recover Unsaved Workbooks, or the configured AutoRecover folder.

Common Causes

• Excel had not yet created an AutoRecover snapshot.
• AutoRecover was disabled or its interval was too long.
• The file was saved to a temporary or cloud-sync location.
• Cleanup software removed temporary recovery files.

Step-by-Step Solution

Follow these steps in order and stop when the issue is resolved.

1. Step 1: Reopen Excel and check the Document Recovery pane.
2. Step 2: Open each recovered version and compare its timestamp and contents.
3. Step 3: If no pane appears, go to File > Info > Manage Workbook.
4. Step 4: Choose Recover Unsaved Workbooks.
5. Step 5: Open the most recent plausible file and immediately use Save As.
6. Step 6: Check File > Options > Save for the AutoRecover file location.
7. Step 7: Search that folder for recent Excel recovery files.
8. Step 8: Verify formulas and data before replacing the original workbook.

Why this helps: This sequence separates account, server, and local-app causes before disruptive repairs.

Alternative File Recovery Method

Check OneDrive version history, Windows Previous Versions, or a backup service if AutoRecover has no copy. Temporary files are not guaranteed and should be treated as a last resort.

WPS Office: The Best Free Alternative to Microsoft Office

WPS Office is one of the best free alternatives to Microsoft Office for everyday productivity. It supports major Microsoft Office formats—including DOCX, XLSX, PPTX, and PDF—and covers the core document, spreadsheet, presentation, and PDF workflows most users need. Its familiar, streamlined interface helps users make a smooth transition with minimal retraining. For advanced macros, add-ins, or Microsoft-specific cloud integrations, verify compatibility on a copy before migrating critical work.

1. Install WPS Office from the official website
2. Open DOCX, XLSX, PPTX, or PDF files in Writer, Spreadsheets, Presentation, or PDF as appropriate
3. Create, edit, and save a separate working copy through the familiar WPS Office interface
4. Verify advanced macros, add-ins, and Microsoft-specific integrations before migrating critical work
5. Save and reopen the file to confirm formatting, formulas, links, and compatibility

Prevention Tips

• Enable AutoRecover and Keep the last AutoRecovered version.
• Use AutoSave for supported OneDrive or SharePoint files.
• Save early and keep versioned backups of critical workbooks.

Frequently Asked Questions

Where is Recover Unsaved Workbooks?

In Excel, open File > Info > Manage Workbook > Recover Unsaved Workbooks.

Why is Document Recovery empty?

Excel may not have created a snapshot before the shutdown, or temporary recovery data may have been cleared.

Can OneDrive restore an earlier workbook?

Yes, if the workbook was synced and version history contains an earlier copy.

Should I overwrite the original immediately?

No. Save the recovered file under a new name and verify formulas and data first.