Recover Previous Version Excel Files Mac

If you accidentally overwrote or deleted data in an Excel file on your Mac, you can often recover a previous version using built-in macOS and Excel features. The fastest methods are the Version History in Excel for Microsoft 365, the macOS Time Machine backup, and the AutoRecover file location. This article explains each method step by step, what to do when they fail, and how to prevent future data loss.

How Excel’s AutoSave and Version History Work

Excel for Mac (version 16.16 and later) includes an AutoSave feature that continuously saves your work to the cloud (OneDrive or SharePoint) when the file is stored there. This creates a version history that you can browse and restore. For files stored only on your Mac’s local drive, AutoSave is off by default, but Excel still keeps temporary AutoRecover copies every few minutes (default interval is 10 minutes) that you can use after a crash or unexpected quit.

Key points:

• AutoSave only works for files saved in OneDrive, SharePoint, or Teams folders.
• Version History shows a list of saved versions with timestamps and who made changes (if shared).
• AutoRecover files are stored in a hidden folder on your Mac and are deleted when you close Excel normally.

Method 1: Restore from Version History (for Cloud Files)

If your Excel file is stored in OneDrive or SharePoint, follow these steps:

1. Open the file in Excel for Mac.
2. Click the file name at the top of the window (next to the red close button).
3. In the dropdown menu, select Version History.
4. A sidebar will appear on the right listing all saved versions with dates and times.
5. Click a version to preview it. If it’s the one you want, click Restore to make it the current version, or Open Version to save it as a separate file.

Note: If you don’t see Version History, your file is not stored in a cloud location. Move it to OneDrive first to enable AutoSave and version tracking.

Method 2: Recover from Time Machine Backup

Time Machine is a built-in macOS backup tool that snapshots your entire drive hourly, daily, and weekly. If you have it enabled, you can restore an earlier version of any file, including Excel files stored locally.

1. Close Excel.
2. Open the folder where the Excel file is located (e.g., Documents).
3. Launch Time Machine from the menu bar (the clock icon) or from System Settings → General → Time Machine.
4. Use the timeline on the right or the arrows to go back to a date before the file was changed.
5. Select the Excel file, then click Restore to bring it back to its original location, or hold Option and click Restore To to save it elsewhere.

If you don’t have Time Machine set up, you cannot retroactively recover files this way. Check System Settings → General → Time Machine to see if backups exist.

Method 3: Find AutoRecover Files

Excel’s AutoRecover feature saves temporary copies of open workbooks at regular intervals. After a crash or forced quit, you may be able to retrieve them.

1. Open Excel for Mac.
2. Go to File → Open.
3. At the bottom of the Open dialog, click Recover Unsaved Workbooks (or look for a folder named “Unsaved Workbooks”).
4. If a list appears, select the file and open it. Then immediately save it to a permanent location.

If the file isn’t there, you can manually navigate to the AutoRecover folder. In Excel, go to Excel → Settings → Sharing and Privacy → AutoRecover. The path is usually:

/Users/[YourUsername]/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/Office 2011 AutoRecover (for older versions) or ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/AutoRecover (for newer versions).

To access this folder, open Finder, press Shift+Command+G, and paste the path. Look for files with .xlsx or .xls extensions that have a timestamp matching your lost work.

What to Do If None of the Above Works

If you can’t find a previous version, try these last-resort options:

• Check the Trash: If you deleted the file, it might still be in the Trash. Right-click it and choose Put Back.
• Look for temporary files: Excel creates temporary files with names like “~$filename.xlsx” in the same folder as the original. These are usually hidden. In Finder, press Shift+Command+. (period) to show hidden files. If you see a ~$ file, open it with Excel.
• Use a file recovery tool: Third-party data recovery software can scan your hard drive for deleted file fragments, but this is not guaranteed and may require paid software. This should be a last resort because it’s not always reliable.

If the file was stored locally and you never enabled Time Machine, the chance of recovery drops significantly. The more you use your Mac after the loss, the higher the chance the old data has been overwritten.

How to Prevent Future Data Loss

The best way to avoid this situation is to set up multiple layers of protection:

• Enable Time Machine: Go to System Settings → General → Time Machine and turn it on. Use an external drive or a network drive for backups.
• Save Excel files to OneDrive or SharePoint: This enables AutoSave and Version History, which is the most reliable way to recover previous versions.
• Adjust AutoRecover interval: In Excel Settings → Sharing and Privacy → AutoRecover, set the save interval to a shorter time (e.g., 5 minutes) to minimize data loss.
• Manually save versions: Use File → Save As and add a version number or date to the file name (e.g., “Budget_2024-03-01.xlsx”). This gives you explicit checkpoints.

Common Misconceptions

Many Mac users believe that Excel’s AutoRecover works like AutoSave for local files. It does not. AutoRecover only helps after a crash, not when you manually save over a file. Also, closing a file normally deletes the AutoRecover copy, so you can’t go back to a version from yesterday if you’ve been working on it since then and saved it multiple times.

Another misconception is that Time Machine backs up every file instantly. It only backs up files that have changed since the last backup, and it keeps hourly snapshots for the past 24 hours. So you can only go back to the last hourly backup, not to a specific minute.

Frequently Asked Questions

Can I recover an Excel file that I overwrote on my Mac without Time Machine?

If you don’t have Time Machine and the file is stored locally, your options are limited. You can check AutoRecover files, but they are usually deleted when you close Excel normally. Third-party recovery software might work if the data hasn’t been overwritten, but it’s not guaranteed.

Does Excel for Mac have a “Restore Previous Versions” like Windows?

No, Excel for Mac does not have a direct “Restore Previous Versions” tab in the file properties as Windows does. Instead, you use Version History (for cloud files) or Time Machine (for local files).

Why is Version History greyed out in Excel for Mac?

Version History is only available when the file is saved to OneDrive or SharePoint. If your file is stored locally, the option is greyed out. Move the file to a cloud folder to enable it.

How do I change the AutoRecover save interval in Excel for Mac?

Go to Excel → Settings → Sharing and Privacy → AutoRecover. There you can adjust the minutes between saves. The default is 10 minutes.

Can I recover a previous version of an Excel file that was shared with me?

If the file is in OneDrive or SharePoint, you can view Version History if you have edit permissions. If you only have view permissions, you may not be able to restore, but you can download a previous version.

Related

• Fish It Admin Abuse Times? Facts & Context
• How to Choose Dishwasher Size, Wash Programs & Water Use
• Word Processor File Formats Explained