How to Restore an Excel File to a Previous Version

Accidentally overwriting hours of work in Excel is one of those gut-drop moments that most people experience at least once. The good news: Microsoft has built several recovery paths into Excel and Windows, and cloud storage adds even more options. The method that actually works for you depends on how your file was saved, where it lives, and which version of Excel you're running.

Why Excel Can Roll Back Changes at All

Excel doesn't just save a single snapshot of your file. Depending on your setup, it quietly maintains version history — a stack of earlier states the file passed through. This happens through a few different mechanisms:

• AutoRecover — a local, time-based backup Excel creates automatically in the background
• Version History in OneDrive or SharePoint — cloud-based saves that log every time the file was saved
• Windows File History or Previous Versions — OS-level snapshots tied to backup settings
• Manual backups — copies you or your IT team deliberately created

Each mechanism works differently and has different limitations on how far back you can go.

Method 1: Use Version History (OneDrive or SharePoint)

If your Excel file is saved to OneDrive, OneDrive for Business, or SharePoint, this is the most capable recovery option available.

How to access it:

1. Open the file in Excel (desktop app or Excel for the web)
2. Click the file name in the title bar (Excel 365) or go to File → Info → Version History
3. A panel opens showing timestamped saves
4. Click any version to preview it in a read-only view
5. Use Restore to replace the current version, or Save a Copy to keep both

Version history in OneDrive typically retains versions for 30 days on personal plans and longer on Microsoft 365 Business plans. Each save event — including AutoSave triggers — creates a new entry, so granular rollback is often possible. 🕐

Key variable: AutoSave must have been enabled when changes were made. If the file was saved locally and only occasionally synced, the version history may be sparse.

Method 2: Recover Unsaved Workbooks via AutoRecover

If Excel crashed or you closed a file without saving, AutoRecover may have preserved a recent draft.

How to find it:

1. Open Excel and go to File → Info → Manage Workbook
2. Click Recover Unsaved Workbooks
3. Browse the list of .xlsb or .xlsx temporary files
4. Open the one you need and immediately Save As to a permanent location

AutoRecover files are stored in a temp folder — typically something like C:Users[Username]AppDataRoamingMicrosoftExcel on Windows. They're not permanent. Excel deletes them after a few days, and they disappear when a file is cleanly closed.

The gap here: AutoRecover captures a snapshot at whatever interval you've set (default is every 10 minutes). If you made significant changes between snapshots, those changes won't be in the recovery file.

Method 3: Use Windows "Previous Versions" (File History or Restore Points)

If your Excel file is stored locally on a Windows PC, the Previous Versions feature may give you access to older copies — but only if File History or System Protection was active beforehand.

How to check:

1. Right-click the Excel file in File Explorer
2. Select Properties → Previous Versions tab
3. If snapshots exist, they'll appear with timestamps
4. Select a version and choose Open, Copy, or Restore

This works independently of Excel itself — it's purely a Windows backup function. Machines on corporate networks often have this configured by IT. Home users frequently find this tab empty unless they've manually set up File History through Settings → Update & Security → Backup.

Method 4: Check for Excel's Built-In Backup Copies

Excel has a lesser-known option under File → Save As → Tools → General Options called Always create backup. When enabled, every time you save, Excel creates a .xlk file in the same folder — one version behind the current save.

If someone enabled this setting on the file or template, look for a file with the same name but a .xlk extension in the same directory. Open it directly in Excel.

This only retains one previous version, so it's a safety net against a single bad save — not a multi-step history.

Comparing Recovery Methods at a Glance

The Variables That Determine What's Actually Available to You

No single method works universally. What you can recover — and how far back — depends on:

• Where the file is saved: local drive, OneDrive, SharePoint, or a network drive each behave differently
• Whether AutoSave was on: required for dense OneDrive version history
• Your Excel version: Microsoft 365 has more recovery infrastructure than Excel 2016 or 2019 standalone
• Your Windows backup configuration: File History doesn't run by default on all setups 🖥️
• How the data was lost: crash vs. manual overwrite vs. accidental deletion each point to different solutions
• IT or organizational policy: business accounts often have longer retention periods and additional backup layers

Someone running Microsoft 365 with OneDrive AutoSave enabled will have a rich, granular version history stretching back weeks. Someone using a locally-saved .xlsx on a machine without File History configured may have only the AutoRecover temp file from 10 minutes before the crash — or nothing recoverable at all.

The method worth trying first is whichever matches how your file was being stored and synced — because that's where the version snapshots actually live. 💾