Data Backup Problems

How to Recover Missing Excel Data After Restarting a Mac

Chanuka GeekiyanageChanuka Geekiyanage Nov 3, 2026 869 views

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.

How to Recover Missing Excel Data After Restarting a Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Log in to OneDrive online

Open your web browser and sign in to your OneDrive account at onedrive.live.com.

2
Locate the Excel file

Navigate through your cloud folders to find the specific Excel spreadsheet that is missing data.

3
Access Version History

Right-click on the file and select "Version history" from the context menu.

4
Restore the correct version

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.

Check OneDrive Version History and Recycle Bin
Check the Recycle Bin: If the file is entirely missing, check the "Recycle bin" tab on the left side of the OneDrive web interface. If found, select it and click "Restore".
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website and download the macOS version of WPS Office.
  2. 2. Open Your Existing Files: Launch WPS Office and open your current Excel (.xlsx) files directly without any formatting loss or conversion steps.
  3. 3. Enable Auto-Backup: Turn on WPS Cloud synchronization to ensure your spreadsheets are automatically saved and versioned as you work.
Fully compatible with Microsoft Excel formats (.xls, .xlsx) and CSV filesBuilt-in WPS Cloud ensures your edits are backed up instantly and reliablyLightweight application that runs smoothly on macOS without freezingClear and accessible version history management to prevent data loss
microsoft office alternative - wps office

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.