How to Recover an Earlier Version of an Excel File

Accidentally overwriting hours of work in Excel is one of the most frustrating experiences in everyday computing. The good news is that Excel and the platforms it runs on have multiple recovery layers built in — and understanding how they work gives you a realistic picture of what's retrievable and what isn't.

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

The methods available to you depend heavily on where your file is stored, which version of Excel you're running, and whether certain features were active before the problem occurred. Someone working in Microsoft 365 with OneDrive sync enabled has very different options than someone using a standalone Excel 2016 installation saving to a local hard drive.

Method 1: Version History in OneDrive and SharePoint ☁️

If your Excel file is saved to OneDrive, OneDrive for Business, or SharePoint, you have access to automatic version history — and it's the most reliable recovery path available.

To access it:

1. Open the file in Excel (desktop or browser)
2. Click File → Info → Version History
3. A panel lists timestamped versions — click any to preview
4. Restore the version you need, or copy data from it manually

OneDrive typically stores dozens of versions going back 30 days for personal accounts, and up to 180 days for Microsoft 365 Business plans. Versions are created automatically whenever the file is saved, so the granularity depends on how often you or Excel's autosave feature wrote to the file.

Key variable: Autosave must be enabled and the file must be actively synced to the cloud. If you were working offline and hadn't synced, that window of changes may not have a cloud version entry.

Method 2: AutoRecover for Unsaved or Crashed Files

AutoRecover is a separate feature from version history. It's designed for situations where Excel crashed or closed before you saved — not for recovering older saved versions of a file you intentionally overwrote.

AutoRecover saves a temporary copy of your open workbook at a set interval (default: every 10 minutes). If Excel closes unexpectedly, it offers to restore the last AutoRecover snapshot on next launch.

To find AutoRecover files manually:

• Go to File → Info → Manage Workbook → Recover Unsaved Workbooks
• Or navigate directly to the AutoRecover folder:
  • Windows:C:Users[Username]AppDataRoamingMicrosoftExcel
  • Mac:~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/

These are .xlsb or .xlsx temp files with timestamp-based names. They're deleted automatically once you close a file normally with a save, so this method only helps when a crash or force-close occurred.

Method 3: Windows File History and Previous Versions

On Windows, if File History or System Restore was configured before the file was changed, you may be able to recover an earlier local version.

To check:

1. Right-click the Excel file (or its folder) in File Explorer
2. Select Properties → Previous Versions
3. If entries appear, select a version and click Restore or Open

This depends entirely on whether File History was turned on and pointing to a backup drive, or whether a restore point existed. On many home PCs, this is disabled by default — making this method unreliable unless it was proactively configured.

Method 4: Recovering from Email Attachments or Shared Copies 📎

Sometimes the simplest recovery path is overlooked: an older copy of the file may already exist somewhere else.

Check:

• Email sent/received folders — if you emailed the file to someone, or received an earlier version
• Teams or Slack file history — files shared in channels are often stored independently
• Download folders — if you downloaded a copy from a web source or email at any point
• Backup software — tools like Time Machine (Mac), Backblaze, or Acronis may hold versioned copies

How These Methods Compare

The Variables That Determine What's Actually Recoverable

No recovery method works universally. The outcome in your specific case depends on:

• Storage location: Cloud-synced files have the strongest version trail; purely local files rely entirely on OS-level backup tools
• Excel version: Microsoft 365 has deeper integration with version history than perpetual-license versions (2016, 2019, 2021)
• Autosave/AutoRecover settings: These must be active before the problem occurs — they can't be turned on retroactively
• How the file was closed: A normal save-and-close often wipes AutoRecover temp files
• Time elapsed: Cloud version histories and AutoRecover files have retention limits
• IT or admin policies: On managed business devices, version history depth and backup schedules may be controlled centrally

🔍 Someone using a personal laptop with Excel 2019 and no cloud sync has a much narrower recovery window than a Microsoft 365 user whose files live in SharePoint with versioning enforced by an IT team.

What This Means Going Forward

The difference between "I recovered my file" and "that version is gone" almost always comes down to what was configured before the loss happened. Version history, AutoRecover intervals, and backup tools are passive systems — they either were running or they weren't.

Understanding which of these layers applies to your current setup — your storage location, your Excel subscription, your OS backup settings — is what determines which recovery path is actually available to you right now.