There are a couple of reasons behind losing Excel files, like hard drive format, program crash, accidental or unexpected device shutting down, unintended deletion, or a virus intrusion. Well, luckily, there are some recovery solutions explained ahead for Mac users. If the Excel files you want to recover are already gone and are unsaved, you can use the three fixes given in the article forward to recover them in substantial part. This guide will help you recover unsaved or deleted excel file from Mac device that you have either shut down or crashed during work.
Part 1: How to Recover Unsaved Excel File on Mac?
Fix 1. Restore Unsaved Excel Files from Mac Temporary Folder
The temporary folder is the most anticipated easy and quick solution to recover an excel document not saved on Mac. The Temporary folder typically contains automatically saved variants of the Excel file you are currently working on. Simply follow the actions given below step by step to recover unsaved Excel files from Mac machines utilizing the Temporary Folder.
- Step 1: Access "Terminal"
- Step 2: Access the Temporary folder
- Step 3: Find temporary items
- Step 4: Find the unsaved file
- Step 5: Recover the file
Go to Applications, click on Utilities, and then you see the Terminal option on your screen. Click on that to access the Terminal.
Now you have to type a text on the following screen "open $ TMPDIR" in the Terminal and then click Enter.
You will see the Temporaryb> folder; once you press Enter, now select the Temporary Items folder.
You have to find the document not saved Excel Mac manually by recognizing it in the Temporary Items folder.
Once you get your hands on the file Right-click on it and then select the Open With option from the drop-down menu, select TextEdit to open the temporary (.tmp) file in a format that you can easily edit and save to the aspired location.
Fix 2. Retrieve Unsaved Excel Files from AutoRecover
AutoRecover and AutoSave features are fundamental characteristics helping you save and recover excel and other files automatically and quickly. You need to configure AutoRecover for keeping the particular files in Excel, and it is mainly helpful in recovering unsaved excel files.
- Step 1: Find the path for AutoRecover files
- Path for Office 2011
- Path for Office 2008
- Path for Office 2016
- Step 2: Find the Excel files
- Step 3: Recover the files
The essential things to consider are AutoRecover files on Office 2011 and 2008 are entirely dissimilar from Office 2016. You need to follow the steps given below to find more helpful answers to recover the unsaved Excel file on Mac.
Open the "Finder" tab and enter the aforementioned appropriate path to find the unsaved files.
Double click on the file you want and then copy them to the location and save it for backup.
Fix 3: Recover Unsaved Excel File in Recent Workbooks
The Recent workbooks is another verified resolution of recovering deleted Excel files on Mac. This method is exclusively fit for the recovery of Excel files unsaved due to the Excel program crashing during work.
- Step 1: Open Microsoft Excel
- Step 2: Access Recent Workbooks
- Step 3: Start Recovery
- Step 4: Locate the wanted file
- Step 5: Open the unsaved file
- Step 6: Put and Save the file to a new location
Open Microsoft Excel, then open the File tab on the upper right corner of the screen, select Open from the options given and then click on it.
Once you click on the Open option, there will be a pop-up menu to find the prospect of the Recent Workbooks option. Click on the Recent Workbooks.
You will see a list upon clicking on Recent Workbooks; the option for Recover Unsaved Workbooks will be listed at the end of the list. Select the Unsaved Workbooks to move to proceed further in Excel recovery on Mac.
Locate the unsaved Excel file from the Recover Unsaved Workbooks folder.
You can do two things here. 1 double click on the unsaved Excel file to open it. 2 right-click on it to find a drop-down menu. Click on the Open option to open the unsaved file.
To save the file, select the Save As option in the File menu of the unsaved file and choose the location to save the file.
Part 2. How to Retrieve Deleted/Lost Excel File on Mac?
Fix 1: Get back Deleted Excel on Mac from Trash Bin
The inadvertently deleted files remain in the Trash for 30 days. Look in the Trash folder in the first place to recover unsaved Excel files.
- Step 1: View the Trash
- Step 2: Identify the unsaved file
- Step 3: Drag for recovery
Go to the desktop on a Mac device, open the Trash folder and search for the unsaved file.
You need to locate the appropriate Excel file, and in case of more than one file, you can search them simultaneously through the search box at the top left corner of the window.
When you find the target Excel file, please right-click on the file, select the Put Back option from the drop-down list, and the file will appear on its previous location. You can also drag the file to an accurate location for recovery where you want to place it.
Fix 2. Rescue Deleted Excel File on Mac with Time Machine
Time Machine is another option to recover deleted/lost Excel files on Mac if you have a good habit of making the corresponding backup data of the lost Excel files.
- Step 1: Get Time Machine
- Step 2: Enter Time Machine
- Step 3: Restore the File
Connect your Time Machine backup disk to your Mac device.
Open the folder that had the deleted Excel file and then click on the Time Machine icon in the Menu Bar and select Enter Time Machine.
You need to check thoroughly for the file with the help of Timeline or scrolling Up and Down arrows to find the Excel file you need precisely. Once you find it select the file and click Restore.
Fix 3: Recover Lost Excel Files Using autosave Backup
Here are the steps to recover an unsaved excel file on Mac. The procedure supports 2011 and other versions by obtaining the backup versions.
- Step 1: Find the Info
- Step 2: Find the Manage Versions option
- Step 3: Choose the backup for recovery
Choose the File tab and then enter the Info option.
Snapping on the Manage Versions option will give you access to all the backups of the unsaved Excel files along with time and date.
When you select the desired backup Excel files that you need to recover, click on them. There will be an option to Restore on the yellow bar. Click on Restore to recover the unsaved file.
Fix 4: Recover Deleted or Lost Excel on Mac via Online Backup
If you use online storage services, like iCloud, Google Drive, OneDrive, etc., to make backups, you can smoothly recover deleted Excel files.
Log in to your iCloud account. Go to Settings>Advanced>Restore Files. To retrieve the Excel file, click on them and then click Restore File.
Access your Google account, and reach Google Drive. Open Trash, find your deleted Excel files. Right-click on the deleted Excel file, and choose Restore to regain the Excel file on your Mac device.
Go to OneDrive and log in. Take a look in the Recycle bin to find the lost Excel file. Right-click on the file and choose Restore to recover the deleted Excel file on your Mac machine.
Part 3: Ultimate Way to Recover Permanently Deleted/Unsaved Excel on Mac with 4DDiG
If the above solutions work nothing for you, you should definitely give it a shot to a professional data recovery tool to help you out. 4DDIG Mac Data Recovery is the expert yet uncomplicated software to recover all kinds of files, including photos, videos, documents, and many more on your Mac hard drive or external disks.
- The software supports macOS 10.10 and above
- Support to recover unsaved or deleted Excel documents for all versions like Excel 2013/2016.
- Aside from Excel/Word/PowerPoint documents recovery, the software also retrieves lost photos, videos, audios, emails, web files and others.
- The software is also 100% secure and supports several devices like cameras, memory cards, SD cards, USB flash drive, exterenal hard drive and more.
- The software offers full control over formatted, corrupted, or lost data on Mac-based devices, and supports 550+ file types.
Steps to Recover Deleted/Unsaved Excel with 4DDIG
- Step 1: Select a Location
- Step 2: Scan and Preview
- Step 3: Recover Mac Files
4DDiG-Mac is the recovery software that you need to install on your Mac device first. Launch 4DDiG-Mac. Select a location to start Mac data recovery. When you click on the Scan button, it will start looking up all lost, deleted, corrupt, and damaged Excel files.
Note: If you require data from the macOS High Sierra and the following system, you must disable SIP first to locate Mac files. Just take a photo of on-screen prompts and follow the steps.
Scanning will allow all deleted files visible to you in the form of a list. You can select the specific file for more details.
Click the Recover button and select a new location to save the recovered files. Please do not save the recovered files to the place where you lost them. This may cause permanent data loss.
If you have unintentionally shut an Excel file without saving it on your Mac device or permanently deleted it by mistake, or Mac shutting down caused your Excel files to get lost due to a power failure or any other reason. Now you know multiple methods to recover unsaved/deleted Excel files, amongst which 4DDiG Mac Data Recovery is reasonably the most suitable option as it renders the quick and easy solution in a single window very efficiently. To get back all your lost Excel files in a flash.
You May Also Like
- Top 10 Recuva Mac Alternatives
- How to Recover Deleted Folders on Mac?
- Easily Recover and Show Hidden Files on Mac
- Recover Deleted Files after Emptying Trash on Mac
- How to Recover Unsaved or Deleted Excel on Mac?
- How to Recover Corrupted or Damaged Excel File on Mac?
- Recover Unsaved or Deleted Word Documents on Mac
- Can't Open Hyperlink in Excel? Here's How to Make it Work