Yesterday afternoon, I was working on an Excel sheet, and suddenly it crashed, leaving me no chance to save the information. How can I recover unsaved Excel data on a T2 MacBook Pro 2019?
Check the AutoRecover folder first!
Excel automatically saves a recovery copy of your work every 10 minutes, provided that AutoRecover is enabled, which is usually the case. This feature is specifically designed to preserve work during a crash.
If you boot your Mac again and reopen Excel, a Document Recovery window will prompt you to save the unsaved Excel file.
Suppose you’re not greeted with a recovery window, find the Autorecover file in the following locations:
Open Finder, press Shift + Command + G then copy and paste the paths below:
- For Office 2016, 2019, or Microsoft 365: ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/
- For Office 2011: ~/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery/
You can also scan your Mac with a data recovery tool like iBoysoft Data Recovery for Mac.
It’ll be easier to find the unsaved Excel file since it can examine the disk thoroughly. As long as the file is still on your Mac, it’ll surely find it.