A Microsoft file hosting and synchronization service.
If the files were in Excel and disappeared on a Mac with Microsoft 365, the most likely places to check are AutoRecover, Document Recovery, OneDrive, and local storage.
- Reopen Excel and look for Document Recovery. If Excel or macOS closed unexpectedly, Excel can open a Document Recovery pane the next time the app starts. Review each recovered file, open the most recent version, and save the files needed.
- Check whether the files were actually saved to OneDrive.
AutoSave works only when the file is saved to OneDrive, OneDrive for Business, or SharePoint Online. On Mac, the file must also be opened from File within Word, Excel, or PowerPoint, then from Online Locations if needed. AutoSave is disabled if the file was:
- saved to a local folder on the Mac
- on a file server or SharePoint on-premises
- in an older format such as .xls
- in a local OneDrive folder while OneDrive sync is paused
- embedded inside another Office file
- Check OneDrive carefully. Since there is only one account, verify the files are in OneDrive and not just missing from Excel’s recent list. Also check whether the files may have been deleted and can be restored from OneDrive. If needed, OneDrive personal can also restore the entire OneDrive to an earlier point in time within the last 30 days. Caution: restoring OneDrive sends files and folders created after the restore point date to the OneDrive Recycle Bin.
- Search the Mac itself. If the file was saved outside OneDrive or had not synced yet, search local storage in Finder. Also check Trash.
- Check the AutoRecover folder on Mac.
In Finder, use Go > Go To Folder and enter:
/Users/<username>/Library/Containers/com.Microsoft/Data/Library/Preferences/AutoRecoveryIf Word or Excel created an AutoRecover copy, it may be there. Save any recovered file immediately. - If the files were recovered but there are multiple versions, keep the newest one. In the Document Recovery pane, compare the date and time under each file name, open the most recent version, then use Save As to keep it.
- For future protection, confirm recovery settings. In Office, AutoRecover should be enabled. On Windows this is under File > Options > Save; the key point is that AutoRecover helps after crashes, while the safest ongoing protection is storing files in OneDrive or SharePoint and using AutoSave.
What likely happened:
- If the workbook was not actually opened from OneDrive/Online Locations, AutoSave may not have been active even with a Microsoft 365 subscription.
- If Excel or the Mac closed unexpectedly, the files may exist only as AutoRecover copies.
- If the files were saved locally, they would not appear in OneDrive until synced or manually saved there.