File Corruption & Recovery

How to Recover Missing Changes When Excel Did Not Save Your Work

Bushra Parveen Oct 1, 2026 868 views

Question details

The user needs to restore unsaved changes or missing data in an Excel spreadsheet.

How to Recover Missing Changes When Excel Did Not Save Your Work

Product: Microsoft Excel
Device & OS: not provided
Scenario: The user was working on an Excel file, but recent edits were not saved properly due to a crash, accidental closure, or sync failure.
Observed behavior: The Excel workbook opens, but the most recent changes, edits, or additions are missing.

Before you start

Before attempting recovery, ensure you do not overwrite the existing file with the same name, as this can permanently erase older recoverable versions in the system cache.

Solution 1Recommended

Recover Using OneDrive Version History

Use this method if your file was saved to OneDrive or SharePoint and you had the AutoSave feature enabled.

Cloud-stored files continuously save changes and keep a history of previous file states. By accessing the version history, you can pinpoint the exact moment before your data was lost and revert to that version.

Sign in to OneDrive

Open your web browser, navigate to OneDrive online, and sign in with your Microsoft account credentials.

Locate the Excel File

Find the Excel workbook that is missing your recent changes in your file list.

Access Version History

Right-click the file and select 'Version history' from the context menu. A pane will appear showing all previous saves with timestamps.

Restore the File

Review the versions, select the one that corresponds to when your missing changes were made, and click 'Restore' or 'Open File' to recover your data.

Tip: You can also access Version History directly from the desktop Excel app by clicking the file name at the top of the window and selecting 'Version History'.

Solution 2

Restore from Excel AutoRecover Files

Use this method if your file was stored locally on your hard drive and AutoRecover was active.

Free Microsoft Office alternative

Prevent Data Loss with WPS Office Smart Backup

If you are struggling with Excel's recovery features, consider switching to WPS Office. It is a free, lightweight alternative that offers highly reliable auto-backup and document recovery functions. It seamlessly handles Microsoft Excel formats while keeping your work safe from unexpected crashes.

1. Download and Install: Visit the official WPS Office website to download and install the free software on your device.
2. Open Your Spreadsheets: Launch WPS Spreadsheets to easily open and edit your existing .xlsx or .xls files.
3. Configure Backup Settings: Go to Menu > Settings > Backup Settings to customize your auto-backup intervals and secure your data.

Completely free and lightweight office suiteBuilt-in Smart Backup feature to securely save historical file versions100% compatible with Microsoft Excel (.xlsx, .xls) formatsFamiliar tabbed user interface for seamless migration without a learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Where are Excel AutoRecover files stored locally on my computer?

By default in Windows, AutoRecover files are saved in the hidden folder: C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. You can find or change your exact AutoRecover file location by opening Excel and going to File > Options > Save.

Can I recover my missing changes if AutoSave and AutoRecover were turned off?

Unfortunately, if AutoSave (for cloud files) and AutoRecover (for local files) were both disabled before the data loss occurred, Excel will not have created the necessary temporary files. In this scenario, unsaved missing changes are typically unrecoverable.

How often does Excel save AutoRecover information?

By default, Excel saves AutoRecover information every 10 minutes. You can decrease this interval to save more frequently (for example, every 1 or 5 minutes) by going to File > Options > Save and adjusting the 'Save AutoRecover information every X minutes' setting.

Document & File Issues