The first thing most people do when they need an older version of an Excel file is right-click → Version History → scroll up expecting to see versions from weeks or months ago. That’s almost always a dead end — because Excel doesn’t store versions beyond 30 days, and only if you’re using OneDrive or SharePoint with specific settings enabled.
Quick Answer
Excel version history goes back up to 30 days, but only for files saved to OneDrive or SharePoint Online — never for local .xlsx files on your C: drive. Versions are created automatically every time you save (or autosave), and older ones expire daily after the 30-day window. No registry tweak, no add-in, no hidden setting extends this limit.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| OneDrive/SharePoint Version History | Open file in Excel Online → File → Version History → click timestamp | Cloud-saved files with autosave enabled | Max 30 days; no versions for local saves |
| Local File Recovery (Windows) | Right-click file → Properties → Previous Versions tab → Restore | Files on NTFS drives with System Protection enabled | Depends on Windows backup schedule; often empty on laptops |
| Excel AutoRecover | File → Options → Save → check AutoRecover location → browse folder | Crash recovery, not version history | Files auto-deleted after 4 days by default; no timestamps in filename |
| Manual Backup Folders | Check folders like \Backups\Q3-2024\ or \Archive\2024-06-12\ | Teams that follow naming conventions | Zero automation — relies entirely on discipline |
| Third-party Tools (e.g., ShadowExplorer) | Install → select volume → browse Volume Shadow Copies → export .xlsx | Advanced users with admin rights | Only works if shadow copies exist — often disabled on SSDs |
Method 1 Deep Dive
Open Revenue-Forecast-Q2-2024.xlsx from OneDrive. Go to File → Version History. You’ll see timestamps like:
- Jun 15, 2024, 3:42 PM
- Jun 14, 2024, 11:07 AM
- Jun 10, 2024, 9:15 PM
- Jun 5, 2024, 2:33 PM
That’s it. No versions before June 5 — even though the file was created May 12. Why? Because OneDrive only retains up to 30 versions *or* 30 days — whichever comes first. If you edit once per day, you get 30 versions. If you edit 5x/day, you still only get 30 days’ worth — oldest versions drop off daily.
Click any timestamp. Excel opens a read-only copy. To restore: click Restore (top-right). This overwrites the current version — no undo. Test it first: copy the restored version to C:\Temp\Forecast-Jun5-RESTORED.xlsx before restoring.
Surprising tip: Version History shows *all* saves — including accidental Ctrl+S spam. If someone hit save 17 times in one session (yes, we’ve seen it), those all appear as separate versions. Sort by date descending, then scan for meaningful edits — look for gaps >2 hours between saves.
Method 2 Deep Dive
For local files — say D:\Projects\Acme-Corp-Bid-2024.xlsx — Version History is grayed out. Your only native option is Windows’ Previous Versions tab.
Right-click the file → Properties → Previous Versions. If the tab is missing, System Protection is off. Enable it: search “Create a restore point” → System Properties → Configure → turn on protection for that drive.
Here’s what you’ll likely see:
| Date Created | Size | Notes |
|---|---|---|
| 2024-06-12 14:22 | 428 KB | Before formatting changes |
| 2024-06-08 09:11 | 392 KB | Final client review copy |
| 2024-06-01 16:45 | 315 KB | Initial draft |
| 2024-05-22 11:03 | 287 KB | — |
| 2024-05-15 13:17 | 251 KB | — |
Note the gap: nothing between May 15 and May 22. That’s because Windows creates restore points manually (via “Create” button) or automatically ~once per week — not per save. And if the drive is an SSD, shadow copies may be disabled entirely by default.
To force a restore point now: press Alt + F → System Properties → System Protection → Create. Takes 30–90 seconds. Do this before major edits.
Cheat Sheet
| Action | Shortcut / Path | Max Age | Works Offline? |
|---|---|---|---|
| Open Version History | File → Version History (Excel Online only) | 30 days | No — requires internet |
| Access Previous Versions | Right-click file → Properties → Previous Versions | Varies (days to months) | Yes |
| Find AutoRecover files | File → Options → Save → AutoRecover file location | 4 days (default) | Yes |
| Open AutoRecover dialog | Alt + F → T → S → Tab ×3 → Enter | 4 days | Yes |
| Enable System Protection | Search “Create a restore point” → Configure → Turn on | Configurable (usually 5–10% disk space) | Yes |
