How to Recover a Previous Version of an Excel File

Accidentally overwriting hours of work — or watching a file corrupt before your eyes — is one of the most stressful moments in everyday computing. The good news is that Excel and the platforms it runs on have several recovery mechanisms built in. The less straightforward news is that which method actually works for you depends heavily on how your file was saved, where it lives, and what version of Excel you're running.

Why Excel File Recovery Isn't One-Size-Fits-All

Excel doesn't store version history in a single universal way. Instead, recovery options come from multiple overlapping systems — some built into Excel itself, some baked into your operating system, and some tied to cloud storage. Understanding which system applies to your situation is the first step.

The core variables are:

• Whether the file is saved locally or in OneDrive/SharePoint
• Which Excel version you're using (Microsoft 365, Excel 2021, Excel 2019, etc.)
• Whether AutoSave or AutoRecover was enabled before the problem occurred
• Your operating system (Windows vs. macOS handle version history differently)

Method 1: Version History in OneDrive and SharePoint 🕐

If your file is stored in OneDrive, OneDrive for Business, or SharePoint, you have access to automatic version history — and this is by far the most reliable recovery method available.

Every time you save a cloud-stored Excel file, Microsoft logs a version snapshot in the background. To access it:

1. Open the file in Excel (desktop or web app)
2. Click File → Info → Version History
3. A panel lists previous saves with timestamps
4. Click any version to open it as a read-only copy
5. From there, you can Restore it or copy specific data out

The number of versions retained depends on your Microsoft 365 subscription tier and storage settings, but in most cases, dozens of previous versions are available going back days or weeks.

AutoSave — which continuously saves changes when working in cloud-stored files — works hand-in-hand with this. If AutoSave was on, version snapshots are frequent and granular. If it wasn't, you'll only see versions at each manual save point.

Method 2: AutoRecover for Locally Saved Files

For files stored on your local drive, Excel's AutoRecover feature periodically saves temporary backup copies to a hidden folder on your computer. This is primarily designed for crash recovery, not intentional version rollback, but it can help if you closed a file without saving or Excel crashed mid-session.

To check for AutoRecover files:

• Go to File → Info → Manage Workbook → Recover Unsaved Workbooks
• Excel will open a folder showing temporary .xlsx or .xlsb recovery files

The default AutoRecover interval is every 10 minutes, though this can be adjusted in File → Options → Save. That interval matters: if you made significant changes in the last 10 minutes before a crash, those changes may not be in the AutoRecover file.

AutoRecover files are temporary. Once you close a file normally (even without saving), Excel typically purges the AutoRecover copy for that session.

Method 3: Previous Versions via Windows File History or macOS Time Machine

Both major desktop operating systems offer filesystem-level version history — but only if it was configured before the problem occurred.

On Windows, right-click the Excel file in File Explorer and select Restore previous versions. This pulls from either File History (if enabled and pointed at a backup drive) or Windows Backup. If neither was set up, this panel will be empty.

On macOS, if Time Machine is running with an external drive or network backup, you can enter Time Machine while the file's folder is open in Finder and browse backward through time to find earlier versions of the file.

Method 4: The "Unsaved Changes" Prompt and Undo History

This is the simplest scenario: you made changes and haven't closed the file yet. Excel's Undo history (Ctrl+Z / Cmd+Z) lets you step backward through recent edits — though undo history is session-based and clears when you close the file.

If you saved changes you didn't mean to keep and the file is still open, some versions of Excel will show the option to Discard Changes when closing, effectively reverting to the last saved state.

What Determines Whether Recovery Is Actually Possible 🔍

Even with all these systems in place, recovery isn't guaranteed. The realistic factors:

• Cloud storage is the most dependable safety net — version history is automatic and doesn't rely on crash behavior
• Local files with no backup setup leave recovery largely dependent on AutoRecover timing
• File format matters — legacy .xls files behave differently from modern .xlsx files in terms of compatibility with recovery tools
• The time gap between versions matters enormously — a 10-minute AutoRecover interval might still mean meaningful data loss
• Shared or network drives may have their own snapshot tools depending on IT configuration

The Skill Level and Setup Gap

Someone running Microsoft 365 with files saved to OneDrive can recover granular versions almost effortlessly. Someone using a standalone Excel license with files on a local drive and no backup software configured is working with much thinner safety margins.

The method that applies to you — and how much of your work is actually recoverable — comes down to the specific combination of your Excel version, your storage setup, and which features were active before something went wrong. That's not something any general guide can determine. Your own file location, subscription, and backup history are the deciding factors.