Office for Mac Issues

How to Recover Excel Files on Mac After an Unexpected Shutdown

Adam Davis Sep 28, 2026 869 views

Question details

Users need to identify and recover their unsaved workbooks when Excel automatically reopens multiple AutoRecovered files following an unexpected Mac shutdown.

How to Recover Excel Files on Mac After an Unexpected Shutdown

Product: Microsoft Excel 2021 for Mac
Device & OS: macOS
Scenario: The Mac shuts down unexpectedly, such as while in sleep mode, leaving Excel workbooks open with unsaved changes.
Observed behavior: Upon restarting the Mac and launching Excel, the application automatically reopens multiple recovered copies of the workbooks, requiring the user to determine which file contains the latest changes.

Before you start

Ensure your Mac is connected to a reliable power source before proceeding, and allow Excel enough time to fully load all recovered documents without forcefully quitting the application.

Solution 1Recommended

Save and Manage AutoRecovered Workbooks

Use this solution to identify the most recent version of your recovered file and safely save your data.

Excel's AutoRecover feature automatically saves a copy of your open workbook at preset intervals. When your Mac recovers from a crash, Excel will open these temporary files. It is crucial to manually save the correct version to prevent permanent data loss, as Excel deletes AutoRecover files when closed normally.

Identify the latest workbook

Review the multiple AutoRecovered workbooks that Excel has opened. Check the data inside and look at the document title or modification timestamp to find the one with your most recent unsaved changes.

Save the recovered file

Click on 'File' in the top Apple menu bar and select 'Save As'. Choose a secure destination on your Mac, rename the file if necessary, and click 'Save'.

Close older versions

Once the correct file is safely saved, close the older or incorrect recovered workbooks. When prompted, you can choose not to save them, which will allow Excel to clear the temporary AutoRecover files from your system.

AutoRecover Cleanup: Excel will automatically delete the temporary AutoRecover files from your hidden system folders once you save the recovered document or deliberately close it without saving.

Solution 2

Troubleshoot Unexpected Mac Shutdowns

Address the root cause of the unexpected shutdowns to prevent future interruptions and protect your Excel files.

Free Microsoft Office alternative

Experience Stable and Reliable Document Management with WPS Office

If you frequently experience crashes or unexpected shutdowns while using Excel on your Mac, WPS Office provides a highly stable, lightweight, and free alternative. Equipped with intelligent Auto-Backup features, WPS Office ensures your spreadsheets are continuously protected against system failures.

1. Download and install WPS Office: Visit the official WPS Office website and download the macOS version. Follow the simple installation prompts to set it up on your Mac.
2. Open your existing Excel files: Launch WPS Office and directly open your existing .xlsx or .csv files. You can continue editing your data seamlessly.
3. Enable Smart Backup: Navigate to 'WPS Office' > 'Preferences' > 'General and Backup' to configure automatic backup intervals, ensuring your work is always secure during unexpected system shutdowns.

Built-in Smart Auto-Backup center to easily retrieve unsaved files after system crashes.Perfect format compatibility with Microsoft Excel (.xlsx, .xls) ensuring no data or formatting loss.Lightweight architecture that consumes fewer Mac system resources, reducing the risk of software freezes.Completely free to use with an intuitive, tabbed interface familiar to Office users.

microsoft office alternative - wps office

Frequently Asked Questions

Where is the Excel AutoRecover folder located on a Mac?

By default, Excel AutoRecover files are stored in a hidden system directory. You can find them by opening Finder, pressing Command+Shift+G, and entering the path: ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/.

Why did Excel AutoRecover not save my most recent changes?

AutoRecover works by capturing unsaved changes at preset intervals (e.g., every 10 minutes). If your Mac shut down unexpectedly before the next interval triggered, any changes made since the last AutoRecover update will unfortunately be lost.

How can I change the AutoRecover save interval in Excel for Mac?

Open Excel, click 'Excel' in the top menu bar, and select 'Preferences'. Click on 'Save' under the Sharing and Privacy section. Here, you can adjust the 'Save AutoRecover info every X minutes' setting to a shorter time for more frequent backups.

Does the AutoRecover feature replace manual saving?

No, AutoRecover is strictly a fail-safe for emergency recovery after an application crash or unexpected power loss. You should continue to manually save your work frequently using Command + S.

Office App Problems