THE EXCEL GUIDE Mastering Data & Spreadsheets

Home
Productivity and Tips

Excel Version History: How to View and Restore Files

Learn how to view and restore previous versions.
By:

Most people assume Excel is quietly saving their work history in the background, ready to bail them out whenever something goes wrong. It's not — not unless one specific condition is met. Excel version history only works when your file is saved to OneDrive or SharePoint. If your file lives on your Desktop, your Documents folder, or a USB drive, the Version History option either won't appear or will be greyed out entirely.

I've been building production reports for a healthcare company since 2017, and I learned this the hard way before I got my workflow locked in. These days I test every feature I write about on both my Dell (Windows 11, Microsoft 365) and my MacBook Air M1, so the steps below reflect how this actually behaves across platforms, not just the Windows-default path most tutorials assume you're on.

By the end of this article, you'll know how to view and restore previous versions of a cloud-saved file, what to do if your file is stored locally, and how Excel version history differs from AutoRecover and Show Changes. If you're newer to managing Excel files in general, the Excel for Beginners starter guide covers the broader context worth having first.

The Condition That Unlocks Excel Version History (and Why Local Files Are Left Out)

AutoSave — which is what generates version snapshots — only activates when a file is saved to OneDrive or SharePoint. Microsoft 365 is required for this. If you're on a one-time-purchase version of Excel (2019 or 2021), AutoSave either doesn't exist or has significant limitations.

If you assume your Office subscription includes everything, you may find version history is unavailable because you're saving locally out of habit. Check the AutoSave toggle in the top-left corner of Excel before you need it.

Excel File Info menu open showing Version History option highlighted on Windows
Version History lives under File > Info — but only appears as an active option when your file is saved to OneDrive or SharePoint.

Step 1: View Excel Version History for a File Saved to OneDrive or SharePoint

Once you've confirmed your file is saved to OneDrive or SharePoint, opening the version history takes about ten seconds.

  1. Go to File > Info.
  2. Select Version History from the right-hand panel.
  3. A pane will open on the right side of your workbook listing all saved versions, each timestamped.

Mac users: the path is the same, but the Info panel layout looks slightly different — the Version History button sits lower in the pane than it does on Windows. Excel Online users: version history isn't inside Excel at all. It lives in the OneDrive file browser. Right-click the file, select Version History, and you'll see the list there.

How Far Back Does Excel Version History Actually Go?

It depends on your account type. Personal Microsoft 365 accounts are capped at the last 25 versions. Work or school accounts connected to SharePoint can be configured by an IT admin to store more (or fewer) versions depending on document library settings. When a version ages past that limit, it's gone permanently — it doesn't go to a recycle bin. For team leads or admins, Microsoft's SharePoint versioning configuration guide covers how to adjust those limits before you hit them.

Step 2: Restore a Previous Version of Your Excel File Without Overwriting What You Have Now

Now that you can see your version list, don't restore anything yet. Preview it first.

Click any version in the history pane and it opens in a separate read-only window. You can scroll through it, check the data, and confirm it's actually what you want. This step matters more than people think — I've seen colleagues restore a version from two days ago, only to realize the problem was introduced four days ago. Previewing before restoring saves you from compounding the mistake.

Once you've confirmed the version is correct, you have two paths:

  • Restore: Replaces the current file with that version outright. The current version doesn't disappear — Excel adds it to the version history — but your active file will reflect the older state.
  • Save As: Open the historical version and save it under a new filename. Nothing gets overwritten, and you can compare both files side by side.

Restoring a previous version doesn't delete your newer versions. The full history remains intact. A lot of people avoid restoring because they're afraid of losing recent work — you don't have to be.

Step 3: Recover an Unsaved Excel File When Version History Isn't Available

If Version History is greyed out because your file is stored locally, AutoRecover is your fallback. It's not true version history — it's more like an emergency snapshot Excel takes every few minutes in case of a crash — but it can save you in a pinch.

  1. Go to File > Info > Manage Workbook. Any auto-saved drafts will appear there.
  2. On Windows, you can also browse directly to the AutoRecover folder: C:\Users\[YourName]\AppData\Roaming\Microsoft\Excel\
  3. The files there have an .xlsb or .xlsx extension and are timestamped. Open the one closest to when things went wrong, then save it immediately under a new name.

For ongoing protection on locally saved files, Windows File History (built into Windows 10 and 11) can back up entire folders on a schedule. It's not Excel-native, but it fills the gap. Pairing that with a clear naming convention for your Excel files (date-stamped filenames, versioned copies) gives you a manual version trail that doesn't depend on the cloud.

When to Use Show Changes Instead of Version History

Version history is for "I need to go back." Show Changes is for "I need to understand what happened."

Version history gives you full file snapshots — the whole workbook at a point in time. Show Changes (found under Review > Show Changes in Microsoft 365) gives you something more granular: a log of exactly which cell changed, what the old value was, what the new value is, who made the change, and when. It covers up to the last 60 days and only works on cloud-saved files.

Common Mistakes With Excel Version History

The most common stumble: AutoSave is silently turned off. If AutoSave isn't running, Excel isn't generating version snapshots, and you won't know until you need one. Check the toggle in the top-left corner of Excel. If it's grey, you're not protected. Turning it on requires a cloud save location, so if the toggle won't activate, that's your signal the file is local.

The second mistake is assuming the Version History option being greyed out is a bug. It's not. It's the feature working as designed. Moving the file to OneDrive and re-opening it will activate version history going forward — but it won't recover history from before the move. For everything related to saving and file placement decisions, the Excel file management guide covers the broader workflow worth getting right.

The third one I still see in 2026: restoring a version without previewing it first. When you're panicking because a formula blew up a report, you just want to go back. But previewing takes thirty seconds, and it's the difference between recovering cleanly and creating a second problem on top of the first.

One last thing. I once spent forty-five minutes troubleshooting a formula error that turned out to be a rogue space character in a cell reference. Being able to roll back to a clean version would have ended that in two minutes. That's version history's real value: not the dramatic recovery moments, but the quiet ones.

Frequently Asked Questions

Why is version history greyed out in Excel?

Version history is greyed out when your file is saved locally — to your Desktop, Documents folder, or an external drive — rather than to OneDrive or SharePoint. It can also appear greyed out if AutoSave is turned off, or if you're using a standalone (non-subscription) version of Excel that doesn't support the feature. Moving the file to OneDrive and enabling AutoSave will activate it going forward.

How far back does Excel version history go?

Personal Microsoft 365 accounts store up to the last 25 versions. Work or school accounts connected to SharePoint can store more or fewer depending on how the document library is configured by an IT admin. Versions that age out past the limit are permanently deleted — they don't go to a recycle bin.

What's the difference between Show Changes and Version History in Excel?

Version history gives you full snapshots of the entire workbook at previous points in time, which you can preview and restore. Show Changes (under Review in Microsoft 365) logs granular cell-level edits — showing exactly what changed, the old and new values, who made the change, and when — covering up to the last 60 days. Use version history to roll back; use Show Changes to understand what happened.

How do I recover an unsaved Excel file if version history isn't available?

Go to File > Info > Manage Workbook to find AutoRecover drafts. On Windows, you can also browse directly to the AutoRecover folder at C:\Users\[YourName]\AppData\Roaming\Microsoft\Excel\ and look for recent timestamped files. AutoRecover isn't true version history — it's a crash-protection snapshot — but it's the best fallback for locally saved files.