'%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 Restore Previous Versions of an Excel File on Mac
Question details
The user needs to recover a recently edited Excel file on a Mac that reverted to an older version after being opened on a mobile device.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Attempting to retrieve lost data after an Excel file unexpectedly reverted to an older state due to a cross-device sync issue.
- Observed behavior
- Recent edits disappeared from the Mac after the file was accessed via a phone, and recent backups are not immediately visible in iCloud or Time Machine.
Immediately make a copy of the currently available file and save it to your desktop under a different name. Do not make any further edits to the original file to prevent overwriting any hidden version histories.
Use Excel's Built-in Version History (OneDrive or SharePoint)
If your file is saved to Microsoft's cloud services, Excel automatically keeps track of older versions, making it the easiest way to recover lost work.
This method relies on OneDrive or SharePoint's continuous saving feature. It allows you to view and restore previous iterations of your file without relying on local Mac backups.
Launch Microsoft Excel on your Mac and open the file that has reverted to the older version.
Click on the file name in the top title bar of the Excel window, then select 'Browse Version History'. Alternatively, you can go to 'File' > 'Browse Version History' in the top menu bar.
A pane will open on the right side of the screen displaying past versions organized by date and time. Click on a version to open it in a new, separate window.
Review the opened version to ensure it contains your missing work. Click 'Restore' to replace the current file, or choose 'Save a Copy' to keep both versions.
Recover Previous Versions via iCloud Drive
If you save your files in iCloud, macOS retains previous iterations of your documents that you can browse natively.
Restore the File Using Time Machine
If local backups are configured, Time Machine can restore the file to the exact state it was in during a past backup.
Try WPS Office for Reliable File Sync and Auto-Backup
Avoid version conflicts across devices by switching to WPS Office. It provides a lightweight, highly compatible alternative to Microsoft Office, featuring robust cloud synchronization and auto-backup features to keep your spreadsheets safe.
Frequently Asked Questions
Why did my Excel file revert to an older version when opened on my phone?
This usually happens due to a syncing conflict. If the phone's Office app was offline or hadn't fully synced the latest changes from the cloud, opening and saving the file on the phone might overwrite the cloud version with the phone's locally cached older version.
Can I recover an unsaved Excel file on Mac if I didn't use Time Machine or iCloud?
You can try checking the AutoRecovery folder. Open Finder, press Command+Shift+G, and enter '~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery'. If your file is there, drag it to your desktop and open it to see if it contains your recent edits.
Does saving over a file permanently delete its previous version?
Not necessarily. If the file is stored in a cloud service like OneDrive, SharePoint, or iCloud, the service retains a version history even after you save over the file. However, if it is saved strictly locally without Time Machine configured, the previous version is usually overwritten and cannot be easily recovered.
How do I prevent version conflicts across different devices?
Ensure that all your devices are connected to the internet and fully synced before closing a document. Always allow the cloud service a few moments to upload changes on one device before opening the file on another device.
