Where Excel stores earlier versions of your file

Excel keeps copies of your file as you work on it, but where those copies live depends on which version of Excel you use and how you save. If you use Excel on Windows or Mac with a Microsoft 365 subscription, your file is likely stored in OneDrive or SharePoint, and Excel automatically saves versions every few minutes. If you use Excel 2021 or earlier standalone versions, or if your file lives only on your computer's hard drive, you have fewer automatic backups — but Windows and Mac both keep file history that you can dig into.

The fastest route depends on where your file actually is right now. Open the file and look at the top of the window: if you see "Saved to OneDrive" or "Saved to SharePoint", use the version history inside Excel. If the file is only on your computer, use your operating system's file recovery tools instead.

Key Takeaways

  • Excel with Microsoft 365 automatically saves versions every few minutes if your file is in OneDrive or SharePoint — you can see all of them in the File menu under Version History.
  • Files saved only to your computer have no automatic Excel versions, but Windows File History and Mac Time Machine can recover earlier copies if you turned them on.
  • You can open an earlier version without overwriting your current file by using "Open a Copy" instead of "Open".
  • If you deleted the file entirely, Windows and Mac recovery tools work differently — Windows uses File History or the Recycle Bin, while Mac uses the Trash and Time Machine.
  • Older Excel versions (2021 and earlier) do not have built-in version history unless you manually save copies yourself.

Recovering a version from OneDrive or SharePoint

If your Excel file is stored in OneDrive or SharePoint, open the file in Excel and go to File at the top left. Click Info, then look for Version History — it appears as a button on the right side of the screen. You will see a list of every saved version with a timestamp showing when it was saved and who saved it.

Click on the version you want to see. Excel opens it in a read-only view so you cannot accidentally change it. If this is the version you want to keep, click Restore at the top of the screen — this replaces your current file with the earlier one. If you want to keep both versions, click Open a Copy instead, and Excel saves it as a separate file with the date in the name.

Version history in OneDrive and SharePoint typically goes back 90 days, though your organization may have set it to longer or shorter. If the version you need is older than that, it is gone from this tool.

Recovering a file saved only on your computer

If your Excel file lives only on your computer's hard drive, Excel itself does not keep automatic versions. You need to use your operating system's built-in recovery tools instead.

On Windows: Open File Explorer and right-click on the folder where your Excel file was saved. Click Restore previous versions (or Properties, then the Previous Versions tab). You will see a list of earlier snapshots of that folder. Click the date you want, then click Restore. Windows copies the folder back to that point in time — all files in it revert to how they were then. This only works if you turned on File History in Windows Settings before you needed it.

On Mac: Open Finder, go to the folder containing your file, and press Command + Delete to open Time Machine. You will see your folder as it looked on different dates. Navigate to the date you want, click on your Excel file, and click Restore. Like Windows File History, this only works if Time Machine was already running.

If you never turned on File History or Time Machine, your computer has no snapshots to recover from, and the file is not recoverable through these tools.

Recovering a file you deleted

On Windows: Open your Recycle Bin (usually on the desktop or in File Explorer). Look for your Excel file in the list. Right-click it and click Restore. Windows puts it back in the folder where it was before you deleted it. If the Recycle Bin is empty or you emptied it, you can still try File History as described above — it may have a snapshot from before the deletion.

On Mac: Open the Trash (usually in the Dock at the bottom of the screen). Find your Excel file, right-click it, and click Put Back. Mac returns it to its original location. If Trash is empty, try Time Machine instead.

Once you empty the Recycle Bin or Trash, recovery becomes much harder and usually requires paid recovery software. Do not empty either one if you think you might need to recover something.

Using AutoRecover and AutoSave in Excel

Excel has two separate features that save your work automatically, and they work differently. AutoSave (available in Excel with Microsoft 365) saves your file to OneDrive or SharePoint every few seconds as you type — this is what feeds into Version History. You can turn it on or off at the top of the screen.

AutoRecover is older and works differently. It saves a temporary copy of your file every 10 minutes (you can change this in Excel Settings) in case the program crashes. If Excel closes unexpectedly, it offers to recover the file the next time you open it. However, AutoRecover does not create versions you can browse — it only saves one temporary copy at a time, and it deletes that copy when you close Excel normally.

To find where AutoRecover saves files on your computer, go to File > Options (Windows) or Excel > Preferences (Mac), then look for Save. The path is listed there. You can manually copy files from that folder if you need them, but this is not a reliable backup method.

Why you cannot recover a version and what to do instead

If you cannot find an earlier version, the most common reasons are: the file is stored only on your computer and you never turned on File History or Time Machine; the version is older than 90 days and was stored in OneDrive or SharePoint; or you are using an older version of Excel that does not have automatic versioning.

If the file is gone and you have no backups, you have lost the data. This is the moment to think about what you can rebuild. If the file contains numbers or lists, you may be able to reconstruct it from other sources — emails, printed copies, or records from other people who worked on it. If it contains analysis or formulas, you may need to rebuild those by hand or ask a colleague if they have a copy.

Going forward, set up automatic backups so this does not happen again. If you use Excel with Microsoft 365, make sure your files are in OneDrive or SharePoint, not just on your computer. If you use an older version of Excel, turn on File History (Windows) or Time Machine (Mac) now, before you need it. You can also manually save copies with dates in the filename — for example, "Budget_2024_Jan15.xlsx" — so you always have a recent backup you can reach for.

Frequently Asked Questions

Can I recover a version if I saved over the file by mistake?

Yes, if the file is in OneDrive or SharePoint. Open Version History and look for the version from before you saved over it — you can restore it or open a copy. If the file is only on your computer, use File History (Windows) or Time Machine (Mac) to recover an earlier snapshot of the folder. If you never turned those on, the earlier version is not recoverable.

How far back does Excel version history go?

OneDrive and SharePoint typically keep versions for 90 days, though your organization may have changed this. Excel on your computer with AutoRecover only keeps one temporary copy at a time. File History and Time Machine keep as many snapshots as your storage space allows, usually going back weeks or months depending on how often they run.

What if my file is corrupted and I need an earlier version that actually opens?

Go to Version History or File History and open several earlier versions, starting from a few days back. Try opening each one in Excel to see which one opens without errors. Once you find a working version, restore it or save a copy. If none of them open, the corruption may have existed in all saved versions, and you may need to rebuild the file from scratch or ask a colleague if they have a clean copy.

Does Excel keep versions if I work offline?

No. If you work offline in Excel with Microsoft 365, changes are not synced to OneDrive or SharePoint until you reconnect to the internet. Once you reconnect, Excel saves your current version, but it does not create separate versions for the time you were offline. If you want multiple versions while working offline, you must manually save copies with different names.

Can I recover a version from a file someone else deleted?

If the file is in OneDrive or SharePoint, yes — Version History shows all versions regardless of who deleted the file, and you can restore it. If the file was only on someone else's computer, you would need access to their File History or Time Machine backups, which usually requires their permission or IT support.