Free tools Windows power users keep installed
One-click scans. No signup required.
“Previous versions” of an Excel file aren’t stored by Excel itself. They come from the place where the file lives (OneDrive/SharePoint, Windows backup features, or macOS Time Machine) and from how the file is saved (AutoSave vs. manual saving).
This guide shows the practical ways to view earlier revisions—then what to do when the version list is missing or doesn’t go far enough back.
As an Amazon Associate I earn from qualifying purchases.
Why you can’t always see previous Excel versions
Excel records workbook history only within the current editing session (for example, undo/redo), not as a searchable archive of prior saved states. Once you close the workbook, the only “previous versions” you can access are those created by your operating system or your storage service.
So the right approach depends on whether your file is stored in OneDrive, SharePoint, or locally on your computer.
#1 Best Overall
Prerequisites: where version history actually comes from
Before you try anything, confirm these details:
- Where is the Excel file stored? OneDrive, SharePoint document library, a local folder, or a network drive.
- Are you using a synced workflow? The version history features below typically require syncing/saving through the service, not only editing a downloaded copy.
- Is AutoSave enabled (if applicable)? If you use Excel with OneDrive/SharePoint, AutoSave helps ensure you’re continually creating service-backed revisions.
- Your permissions. Version history on OneDrive/SharePoint depends on access rights.
Method 1: See previous versions in OneDrive or SharePoint (recommended)
If your workbook is in OneDrive or a SharePoint document library, you can usually view and restore prior revisions right from the file’s version history.
Excel on the web + Version history
This is the fastest route when you open the workbook through a browser.
- Go to office.com and sign in.
- Open Excel.
- Open your workbook from OneDrive or SharePoint.
- In the ribbon, click File.
- Select Info.
- Look for Version History (or See Version History) and click it.
- A side panel opens showing dated versions. Click a version to preview.
- Choose Restore to replace the current file with the selected revision, or Save As (when offered) to download that version as a separate file.
OneDrive website + Version history
If you prefer using OneDrive’s file UI directly, this method gives you the cleanest version list.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →- Go to onedrive.live.com and sign in.
- Navigate to the folder containing the Excel file.
- Right-click the workbook (for example, Budget.xlsx).
- Select Version history.
- Browse versions by date/time.
- Select a version to preview.
- Click Restore to revert, or Download to keep the old copy without overwriting the current one.
SharePoint document library + Version history
On SharePoint, version history is managed by your site’s settings and permissions. You may see fewer or more features than OneDrive.
- Open your SharePoint site.
- Go to the Documents library where the Excel file is stored.
- Find the workbook and click it once (or hover and click the … menu).
- Choose Version history.
- Use the list to preview older revisions.
- Select a version, then choose Restore (or Download, depending on what the UI offers).
Method 2: If AutoSave is on, recover an earlier state
AutoSave doesn’t create a separate “magic rewind button.” Instead, it ensures your edits are periodically saved back to the service, where version history can capture them.
Confirm AutoSave behavior
In Excel for Windows/Mac, check whether the workbook is connected to OneDrive/SharePoint and whether AutoSave is enabled.
- Open the workbook in Excel (desktop app).
- Look for an AutoSave switch in the top bar.
- If AutoSave is On, recent edits should show up as later versions in service-backed version history.
- If AutoSave is Off, you might only see versions when you manually saved.
Use the File menu to open version history
When you’re in the desktop Excel app, the UI often routes you into the same version history panel as the web version.
- In Excel, click File.
- Select Info.
- Click Version History or Manage Workbook → version options (wording varies by build).
- Pick the revision you need and restore/download it.
Method 3: Windows Previous Versions (File Explorer + restore points/backups)
If the file is stored locally on Windows (for example, C:\Users\YourName\Documents), you may still be able to see older copies via Windows’ Previous Versions feature. This depends on whether system protection (System Restore) or other backup tools were enabled.
Check Previous Versions in File Explorer
- Open File Explorer.
- Navigate to the folder containing the Excel file.
- Right-click the workbook and select Properties.
- Go to the Previous Versions tab.
- If versions exist, you’ll see entries with timestamps.
- Select a version and click Open to preview.
- Click Copy to copy that version to a safe location.
- Open the copied file in Excel.
What to do if Previous Versions doesn’t show
If the Previous Versions tab is missing or empty, you generally don’t have Windows snapshot backups for that location/time range.
- Verify you’re right-clicking the actual file and not a shortcut.
- Check whether the file was moved to a different drive after edits (snapshots are drive-specific).
- If you use a third-party backup (Acronis, Macrium, etc.), check their restore UI instead.
Method 4: macOS Time Machine (local Mac files)
On macOS, Time Machine can provide “previous versions” as restored snapshots of the file at earlier dates.
Restore an earlier Excel file revision
- Locate the Excel file in Finder.
- Open Time Machine (either via the menu bar icon or by selecting Enter Time Machine).
- Use the timeline to jump to the date/time you want.
- Select the Excel file revision as it appears in that snapshot.
- Click Restore to bring it back (or use Restore to overwrite, depending on your preference).
Open the restored copy safely
- If you’re not sure what’s different, restore to a new folder first.
- Open the restored workbook in Excel and immediately Save As to create a new stable copy.
Method 5: Search for backups and copies (when no versioning is available)
If you don’t have OneDrive/SharePoint version history and Windows/macOS snapshots aren’t available, you can still sometimes recover earlier states using Excel’s recovery files and your system’s temp/backup folders.
Excel AutoRecover files (.asd)
Excel can create AutoRecover files during crashes or unexpected closes. These aren’t guaranteed, but they’re worth checking.
Rank #4
- In Excel, go to File → Options.
- Select Save.
- Look for the AutoRecover file location (copy the path).
- Open that folder in File Explorer/Finder.
- Look for
.asdfiles and open the most relevant candidate in Excel.
Windows and macOS temporary/backup folders
Depending on your Excel settings and how Windows stores files, you may find recoverable copies in backup-style folders.
- Check the folder you noted in Excel for AutoRecover.
- Search your drive for filenames like ~$yourfile.xlsx (Excel temporary lock files) or similar patterns.
- On Windows, also look for
Documents,Desktop, and your Downloads folder for copies you may have saved while troubleshooting.
Check email and sync folders for older attachments
If the file was shared externally (for example, by email), older versions often exist as attachments. Search your mailbox for the workbook name or send date.
- In Outlook or the web, search for the exact filename (example: Budget.xlsx).
- Sort by date, then download the earliest reliable copy.
Common mistakes that make previous versions disappear
These issues are responsible for most “version history is gone” cases:
- Working on a downloaded copy. Editing a local copy you later upload won’t generate granular OneDrive/SharePoint versions for the local changes while you were offline.
- AutoSave off. You may only get versions for manual saves, and changes between saves won’t appear.
- Overwriting via Save As in the same name. Restoring/overwriting the current file replaces the history view you’re trying to recover (you can still restore an older version, but keep track of which one you changed).
- Permission limits. On SharePoint, version history depends on site settings and your access role.
- Retention limits. Many services keep only a rolling window of versions.
Troubleshooting checklist
If the version history panel doesn’t show what you need, use this checklist before giving up.
OneDrive/SharePoint: version history doesn’t appear
- Confirm the file is actually in the OneDrive/SharePoint location (not a local synced folder that lost connection).
- Wait a few minutes after edits, then check again—version creation can lag behind saving.
- Check you’re signed into the same Microsoft account that owns the storage.
- Try accessing version history from the service website (OneDrive/SharePoint) rather than only from Excel.
- On SharePoint, confirm you have read access and that the library has versioning enabled.
Windows Previous Versions: tab missing
- System Protection may be disabled on that drive. You’d need it enabled in advance for snapshots to exist.
- The file might be on a network drive or external drive where the feature isn’t supported.
Excel: AutoRecover files aren’t finding anything
- Double-check the AutoRecover file location path in Excel.
- Search by modification date around when the crash happened.
- If the workbook was recently created and the crash occurred early, there may not be any meaningful
.asdoutput yet.
Which method should you use?
Pick the method that matches where your workbook lives and what you enabled in advance.
| Where the file is | Best method | Most common limitation |
|---|---|---|
| OneDrive | OneDrive Version history | Only versions within retention window |
| SharePoint library | SharePoint Version history | Library/versioning settings + permissions |
| Local Windows folder | File Explorer Previous Versions | Snapshots enabled only if System Protection was on |
| Local macOS folder | Time Machine | Time Machine must have been running and backing up |
FAQs
Can Excel show previous versions of a file I never saved to OneDrive/SharePoint?
No. Excel itself doesn’t maintain a historical version list for a local workbook. You’ll need Windows Previous Versions, macOS Time Machine, or an external backup/search for copies.
Will Version history work for deleted files too?
Often yes, but it depends on the service and retention. OneDrive/SharePoint typically keep deleted items in a recycle bin and may keep versions for a period. Check the service recycle bin first.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →How far back can I go with version history?
It varies by platform, account type, and administrator settings. OneDrive and SharePoint generally retain multiple revisions, but not indefinitely.
What if the older version won’t open or looks corrupted?
Download/restore a different version from the list and try again. If a restored version was impacted by a bad save, another timestamp may be cleaner. After restoring, use Save As immediately to create a fresh workbook.
Bottom Line
If your Excel workbook is in OneDrive or SharePoint, version history is usually the most reliable way to see and restore previous versions—directly from the file’s version list. For local files, Windows Previous Versions or macOS Time Machine are your best bets, with Excel AutoRecover as a crash-focused fallback.
When in doubt, start by identifying where the workbook was stored and whether any system/service versioning was enabled before the problem date.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
