'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Recover Excel Work After a Freeze or Crash on Mac
Question details
The user needs to recover missing changes in an Excel workbook after the application unexpectedly froze, crashed, or undid recent edits.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Recovering unsaved or lost spreadsheet edits following an application freeze, unexpected closure, or automatic undo event.
- Observed behavior
- Recent edits are missing because Microsoft Excel became unresponsive and closed unexpectedly before manual saves could be successfully applied.
Before attempting recovery, ensure your Mac has a stable internet connection if you rely on OneDrive, and do not create or save a new file with the identical name to avoid overwriting your hidden recovery data.
Restore an Earlier Version via OneDrive Version History
Use this method if AutoSave was enabled and your Excel file was synced to OneDrive for Business or SharePoint Online.
When AutoSave is enabled for cloud-synced files, Microsoft constantly saves your progress. Version History allows you to retrieve the exact state of your document from immediately before the freeze occurred.
Log in to your OneDrive for Business or SharePoint Online account via a web browser on your Mac.
Navigate through your cloud folders to find the specific Excel file that was affected by the crash.
Right-click the file and select 'Version history' from the context menu to view all previously saved states.
Browse the list of saved versions by date and time, select the most recent version logged just before the application froze, and click 'Restore'.
Recover from the Local Excel AutoRecovery Folder
If your file was saved locally instead of the cloud, Excel may have generated an emergency backup in the hidden application support directory.
Restore the Workbook from a Time Machine Backup
If AutoSave was disabled and no temporary AutoRecovery file exists, you can revert the folder to a previous state using macOS Time Machine.
Avoid Freezes and Data Loss with WPS Office
If Microsoft Excel frequently freezes or crashes on your Mac, consider switching to WPS Office. It provides a lightweight, highly stable environment for all your spreadsheet tasks with seamless format compatibility and robust automatic backup features.
- 1. Download and Install WPS Office: Visit the official WPS website to download the Mac version for free and install it in seconds.
- 2. Open Your Existing Spreadsheets: WPS Office automatically recognizes and opens your existing Excel files natively without altering their formatting.
- 3. Enable Smart Auto-Backup: Go to settings and verify the auto-backup feature is active to ensure your progress is always saved safely in the background.
Frequently Asked Questions
Where are Excel AutoRecovery files saved on a Mac?
Excel AutoRecovery files are stored in the hidden user Library folder. The specific path is /Users/<username>/Library/Containers/Microsoft Excel/Data/Library/Application Support/Microsoft. You can access it by holding the Option key while clicking the 'Go' menu in Finder.
Can I recover my Excel work if AutoSave was turned off?
If AutoSave was disabled, your best option is to check the local AutoRecovery folder for a temporary backup file. If the file is not there, you can attempt to restore a previous version of the document from a Time Machine backup, provided you have it set up on your Mac.
Why does Excel freeze or close unexpectedly on my Mac?
Excel may freeze due to a variety of reasons, including handling unusually large datasets, inadequate system RAM, corrupted third-party add-ins, or running an outdated version of macOS or the Office suite. Keeping your software updated generally improves stability.
