Unfortunately, there isn't a straightforward way to restore a previous version of an Excel file on a Mac after overwriting and saving changes. However, you can try using Time Machine or a third-party backup service to restore a previous version of the file. If you have Time Machine enabled, you can go to the "Time Machine" menu and select "Enter Time Machine" to browse through previous backups of your Excel file. If you don't have Time Machine, you can also try using a cloud backup service like Google Drive or Dropbox to restore a previous version of the file.
Many people are concerned about losing the latest version of their Excel file on Mac, so they frequently press Command and S to save it. However, this can be a problem, especially when the Mac automatically changes the data in Excel without permission. Fortunately, it is possible to recover previous versions of an Excel file on Mac, and this can be done in Microsoft Excel for Mac 2011, 2016, and 2020.
On a Mac, if you're working on an Excel file or have kept the Excel opening all the time, you can try pressing Command and Z buttons at the same time to revert back to an older version of the Excel file. This method can be repeated multiple times to retrieve previous versions.
On a Mac, many software tools, including Excel, automatically save versions of documents whenever you perform actions like opening, duplicating, closing, or deleting them. If you need to restore a previous version of an Excel file, you can easily do so. To restore a previous version of an Excel file on Mac, you can follow these steps.
Save a previous version of an Excel file on Mac by opening the file, going to "File" > "Save As", and choosing a new location to save the file with a different name, allowing you to recover the previous version.
If you only need to get back the previous version of the Excel file on Mac, I think method 2 will do. However, if the Excel file is lost or deleted, you can restore it only with the help of a professional tool, like Deep Data Recovery for Mac. In the following, how to find permanently deleted or lost Excel files on Mac with Software.
Download Deep Data Recovery for Mac on your computer, a virus-free and trustworthy data recovery software designed for recovering Excel files on Mac, compatible with Excel and macOS Mojave and former versions.
The software is set to scan for all supported file types by default, so you'll need to uncheck any unwanted file types, leaving only the "Documents" option selected, before clicking "Next" to proceed with the extraction of files.
All hard drives of your Mac are listed in the main window, from which you need to select the one where the lost Excel file was located. Clicking "Scan" will initiate the software to scan your Mac for the Excel worksheets.
Free data recovery software can quickly scan your Mac for Excel files, listing all found worksheets in a result window. Simply select the desired file and click "Recover" to save it to your Mac again.