How to Recover an Unsaved Excel File on Mac

Excel may reopen a workbook after an application crash, power loss, or macOS restart. That recovery copy is temporary evidence, not a finished file. Save it under a new name before calculating formulas, refreshing data, or closing the recovery window.

First check: Reopen Excel once and inspect Document Recovery. If a workbook appears, choose Save As, create a separate copy, and verify the newest data before touching the original.

An unsaved workbook, overwritten cloud workbook, deleted file, and corrupted workbook need different tools. Identify what happened before trying broad Finder searches.

1. Let Excel complete crash recovery

1. Open Excel after the unexpected shutdown.
2. Look for a Document Recovery pane, recovery prompt, or workbook opened automatically.
3. Open every candidate whose timestamp matches the lost session.
4. Select File > Save As and use a name such as budget-recovered-01.xlsx.
5. Save a second candidate as -02 rather than overwriting the first.

Do not dismiss the recovery pane because a candidate has an unfamiliar name. AutoRecover labels and temporary filenames may not match the title you intended.

2. Check the save settings on that Mac

Microsoft's Office for Mac guidance places AutoRecover controls under the application's preferences:

1. Open Excel > Preferences.
2. Under Output and Sharing, select Save.
3. Confirm whether Save AutoRecover info is enabled.
4. Note the configured interval.

Unlike Word and PowerPoint, Microsoft does not consistently publish one current Excel for Mac recovery-folder path across all supported builds. Avoid pasting obsolete container paths from forums into Finder and assuming an empty result proves the workbook is gone. The app's recovery pane and configured behavior are stronger evidence.

3. Search for a workbook that may have been saved elsewhere

If Excel has no recovery candidate, the workbook may already exist under another name or account.

1. In Excel, inspect File > Open Recent and note each location.
2. In Finder, search for .xlsx, .xlsm, or a distinctive part of the filename.
3. Sort results by Date Modified and display the full folder path.
4. Check Documents, Downloads, iCloud Drive, OneDrive, and any mounted work drive.
5. Duplicate a likely workbook before opening it.

If macros matter, preserve the .xlsm format. Saving a macro-enabled workbook as .xlsx removes VBA content and can turn a successful recovery into a partial one.

4. Validate the workbook, not just the file

Excel files can open while still missing crucial work. On each copied candidate, check:

• the last rows or columns entered;
• every worksheet tab, including hidden sheets;
• formulas in cells edited near the interruption;
• named ranges, filters, and table boundaries;
• charts, PivotTables, and conditional formatting;
• external links, queries, and macros.

Do not click Refresh All before comparing values. A refresh can replace cached results, contact unavailable sources, or make the recovered state harder to reconstruct. First save a static copy and record any warning Excel displays.

5. Use version history for OneDrive or SharePoint

If the workbook had been saved to OneDrive or SharePoint, open Version History from Excel or the web file list. Preview versions around the loss time and verify the latest affected cells before restoring.

AutoSave is normally enabled for eligible Microsoft 365 files in those cloud locations. It works every few seconds, while AutoRecover is designed for interruption recovery. A cloud version can therefore preserve changes not present in the local emergency copy.

Save an older version separately when you need formulas from one version and recent entries from another. Restoring immediately can hide the comparison you still need to make.

6. Use the correct fallback

For a workbook saved locally and later deleted, inspect Trash and then Time Machine if that folder was backed up. Open the original folder before entering Time Machine so the timeline targets the correct location.

For a workbook that exists but produces errors, duplicate it before attempting repair. Microsoft documents Open and Repair for Windows Excel, but that exact command may not be available in the Mac build. On Mac, try opening a copy, exporting readable sheets, or opening it in another compatible environment without changing the source.

If you intentionally closed Excel and selected Don't Save, AutoRecover may have been removed. Search for previously saved copies, cloud versions, email attachments, and backups rather than expecting a crash-recovery file.

Pick the recovery route by event

Final acceptance test

Save the best candidate as a new workbook, close Excel completely, and reopen it. Recalculate only after the baseline copy is safe. Confirm that formulas return expected results, links point to intended sources, charts use the correct ranges, and macros are still present where applicable.

Give the final file a normal name only after this check. Keep the untouched candidate for a few days or until another person confirms the workbook's critical totals.

Improve protection for the next workbook

Enable AutoRecover in Excel > Preferences > Save and choose a reasonable interval. Save important Microsoft 365 workbooks to OneDrive or SharePoint when AutoSave and version history are appropriate. For models with external data, macros, or regulatory importance, keep separate dated checkpoints because cloud synchronization is not a substitute for an independent backup.

Sources

• Save a file in Office for Mac
• What is AutoSave?
• Repair a corrupted workbook
• Recover your Word files and documents