How to Recover Missing Excel Data After Restarting a Mac
Question details
The user needs to recover recent Excel workbook data that went missing after restarting a Mac due to OneDrive synchronization failures or backup inconsistencies.

- Product
- Microsoft Excel / OneDrive
- Device & OS
- Mac
- Scenario
- The user restarted their Mac, potentially to resolve a system issue, and subsequently discovered that months of recent updates to a frequently used Excel file are missing.
- Observed behavior
- The most up-to-date version of the Excel file cannot be found. OneDrive shows an outdated version, Time Machine has a slightly newer but still incomplete version, and local drives lack the latest edits.
Stop making new changes or saving over the existing Excel file immediately to prevent overwriting any hidden or temporary versions that might still be recoverable on your drive or in the cloud.
Check OneDrive Version History and Recycle Bin
Since the file was saved in OneDrive, checking the cloud's built-in version history is the most reliable way to find recently synced edits that might not be visible on your local Mac.
This method bypasses local synchronization glitches by directly accessing the files stored on Microsoft's servers. It is highly effective if OneDrive successfully uploaded your changes before the Mac restarted.
Open your web browser and sign in to your OneDrive account at onedrive.live.com.
Navigate through your cloud folders to find the specific Excel spreadsheet that is missing data.
Right-click on the file and select "Version history" from the context menu.
Review the dates and times of the previous versions listed on the left panel. Select the most recent correct version, and click "Restore" to overwrite the current file, or "Download" to save a separate copy.

Restore from Mac Time Machine
If a copy of the Excel file was stored locally on your Mac's hard drive, Time Machine might have captured the recent data before the restart.
Search for Temporary AutoRecovery Files
Excel for Mac creates automatic recovery files while you work. These might still exist in hidden system folders if the application closed unexpectedly during the restart.
Try WPS Office for Reliable Cloud Backups on Mac
Dealing with missing files and broken OneDrive synchronization can be incredibly frustrating. WPS Office provides a free, lightweight, and highly compatible alternative for Mac users. With reliable built-in cloud synchronization and automatic backups, you can work securely without worrying about losing your spreadsheets during system restarts.
- 1. Download and Install: Visit the official WPS website and download the macOS version of WPS Office.
- 2. Open Your Existing Files: Launch WPS Office and open your current Excel (.xlsx) files directly without any formatting loss or conversion steps.
- 3. Enable Auto-Backup: Turn on WPS Cloud synchronization to ensure your spreadsheets are automatically saved and versioned as you work.

Frequently Asked Questions
Why didn't Time Machine back up my OneDrive files?
Time Machine only backs up files stored physically on your Mac's local drive or attached volumes. If your OneDrive is configured to use 'Files On-Demand', the actual files reside only in the cloud to save space, meaning Time Machine bypasses them during its backup process.
Where does Mac store Excel AutoRecovery files?
AutoRecovery files on a Mac are typically stored in a hidden system folder. You can access them by opening Finder, holding the Option key, clicking 'Go' > 'Library', and navigating to Containers > Microsoft Excel > Data > Library > Preferences > AutoRecovery.
How do I prevent losing Excel data during a Mac restart?
Always manually save your work (Command + S) and verify that your cloud service, such as OneDrive, displays a 'Sync complete' status icon before restarting. You can also save a duplicate of highly important files to a purely local folder, like your Documents folder, to guarantee Time Machine captures them.




