'%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 an Excel File After Clicking Don't Save on Mac
Question details
The user needs to know if it is possible to retrieve unsaved spreadsheet edits after accidentally clicking the 'Don't Save' prompt upon closing Microsoft Excel.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Closing a modified Excel workbook and accidentally confirming the prompt to discard changes.
- Observed behavior
- Excel permanently discards unsaved modifications when 'Don't Save' is clicked, bypassing standard recovery safety nets within the application.
Before attempting recovery, check if your Excel files were automatically syncing to OneDrive, iCloud, or if you had a Mac Time Machine backup drive plugged in during your working session.
Search the Mac AutoRecovery Folder
Check Excel's native AutoRecovery directory. While clicking 'Don't Save' usually forces Excel to delete these temporary files, a system glitch might have left a residual backup intact.
Excel for Mac generates temporary backup files at regular intervals if the AutoRecover feature is turned on. By design, these files are purged if you close the workbook and intentionally click 'Don't Save'. However, in rare instances—such as a concurrent application freeze or sync interruption—the file might remain in the hidden Library directory.
Click anywhere on your Mac desktop to activate Finder, then click 'Go' in the top menu bar and select 'Go to Folder'.
Type the exact path: ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery and press Return.
Look for files that begin with 'AutoRecovery save of' followed by your workbook's name. Check the Date Modified column to find your most recent session.
Drag the located AutoRecovery file to your Desktop. Double-click it to open it in Excel, and immediately use 'Save As' to create a permanent copy.
Restore from Mac Time Machine Backup
If you have Time Machine configured and active, you can revert the folder containing your Excel file to an earlier state before the application was closed.
Check Cloud Version History (OneDrive or iCloud)
If your Excel file was stored in a synchronized cloud directory, intermediate saves might have been uploaded in the background while you were working.
Never Lose Your Hard Work Again with WPS Office
Worried about Excel's strict deletion of unsaved files? Switch to WPS Office for Mac. It offers a powerful built-in Auto Backup center that intelligently safeguards your active spreadsheets, ensuring you can easily retrieve your data even after sudden closures or accidents.
- 1. Download the Installer: Visit the official WPS website and download the Mac version of WPS Office.
- 2. Install on Mac: Open the downloaded .dmg file and drag the WPS Office icon into your Applications folder.
- 3. Edit Securely: Launch WPS Office and directly open your existing Excel spreadsheets to enjoy safer, backed-up document editing.
Frequently Asked Questions
Why does Excel delete the AutoRecover file when I click Don't Save?
When you select 'Don't Save', Excel interprets this action as an explicit command that you do not want to keep any of the recent modifications. Consequently, it cleans up your hard drive by automatically purging the temporary AutoRecover files associated with that session.
Can third-party Mac data recovery software restore my unsaved edits?
Generally, no. Data recovery software is designed to retrieve files that were written to the disk and then deleted. Because unsaved edits only existed in your Mac's temporary memory (RAM) and the temporary AutoRecover file was overwritten or purged, third-party recovery tools typically cannot piece together the lost data.
How do I turn on AutoSave in Excel for Mac to prevent this?
To use the real-time AutoSave feature in Excel for Mac, you must save your workbook to a Microsoft cloud service, such as OneDrive or SharePoint. Once the file is saved there, toggle the 'AutoSave' switch located in the top left corner of the Excel window to enable continuous background saving.
Where does Mac temporarily store unsaved Microsoft Office files?
Mac stores temporary AutoRecovery files for Microsoft Office applications in a hidden system library folder. For Excel, the default path is ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery. You must use the 'Go to Folder' utility in Finder to access this location.
