Open Autorecover Excel Files Excel For Mac

  

Did you encounter a crash of Word, Powerpoint or Excel? And you want to know where to find the autorecovery files?
Or are you working on files and leave them open for several days and want to make copies each hour or so, just in case, of the recovery files, e.g. with ChronoSync?

  1. Disable Excel Autorecover
  2. Autorecover File Location

AutoRecover feature is available in excel when excel shuts down abnormally or when it is not responding, it automatically recovers the last saved and open file for us and it provides us with two different options, the first being if we want to keep the changes which the files have or we can discard it if we have already saved the data, it is a very useful feature of excel to avoid losing important data, the files are saved at certain intervals which can be defined by the user. Check the files with the name AutoRecovery save of and select the Excel file you want to retrieve. Of course, you can rename the file and add XLS extension instead. Double click the XLS file, which you can open and preview restored Microsoft file on crashed Mac. Click the file menu and choose the Save As option to save the AutoSaved file. Excel for Mac Basic Quick Reference Guide The Excel for Mac Program Screen Keyboard Shortcuts Getting Started Create a Workbook: Click File on the menu bar and select New Workbook or press Cmd + N. Open a Workbook: Click File on the menu bar and select Open or press Cmd + O. Select a recent file or navigate to the location where the file is saved.

The location of the recovery files of Word and Powerpoint is well known:

/Users//Library/Containers/com.microsoft.Word/Data/Library/Preferences/AutoRecovery and
/Users//Library/Containers/com.microsoft.Powerpoint/Data/Library/Preferences/AutoRecovery

Disable Excel Autorecover

You can also visit https://www.fonelab.com/resource/recover-lost-or-unsaved-excel-files-on-mac.html?utmsource=youtube&utmcampaign=fonelabrecoverexcelmac&.

You can navigate with Finder to that path and find your recovery files there.

Many sites make you believe that Excel works the same way. Even Microsoft believes the com.microsoft.Excel/Data/Library/Preferences/AutoRecovery path exists and contains your valuable recovery files. Perhaps for some people the files are actually there. Perhaps that is the case for some versions of Excel for Mac. But after reading hundreds of comments on dozens of forums I saw that I was not alone in not finding the path at all. The tip to enter open $TMPDIR in Terminal (look in com.Microsoft.Excel) did not work either. Not even for Word files. I work in the the latest version of Excel 365 (16.21.1), so that cannot be the problem.

So, what I did is the following: I added Terminal to the apps that have full Disk Access (System Preferences/Security&Privacy). Then I set autorecovery to 2 minutes in Excel, created the Excel file Test2xxx.xlsx in the Documents directory and waited 3 minutes. Then I opened Terminal and typed sudo find / -type f -iname “*test2xxx*”

There they were: 3 other files besides my original file!
The file ~$test2xxx.xls (very small) in the same directory as my original folder and
/Users//Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/
containing 2 files: test2xxx.xlsx.alias (very small) and test2xxx((Autorecovered-)).xlsb. I duplicated, renamed and moved the latter to another directory and opened the file. It turned out to be the recovery file!

Files

Autorecover File Location

To be able to see and recover this recovery file:
Open Terminal
In Terminal, paste the following: defaults write com.apple.finder AppleShowAllFiles YES.
Press return
Hold the ‘Option/alt’ key, then right click on the Finder icon in the dock and click Relaunch
Then navigate in Finder to the path of the recovery file(s)!

The last test was to open Finder with the “Autorecovered” file visible. Then Force Quit Excel and see that the “Autorecovered” file was still there. I got the message that I could reopen Excel and recover my file. I clicked OK and there was my file again!

Please note 1: when you save your file and quit Excel, the corresponding “Autorecovered” file(s) will disappear

Please note 2: autorecovery only works AFTER you save a new file (the file has to have a name)

Best photo edit apps for mac. The Mac suite of Office 365 also consists of OneNote and OneDrive. Autorecovery is not needed there, because both are synced almost realtime with the cloud.