Outlook and Excel

Check Outlook on the web and OneDrive online first; if the missing mail, calendar events, and spreadsheets exist there, repair the Mac’s local synchronization without risking the server copies.

1. Determine whether Outlook data is missing or only not displaying on the Mac

1. Sign in to the affected account through its webmail service.
2. Check:
   • Older and newer email.
   • Previous and upcoming calendar months.
3. If everything appears online, the mailbox data is intact and the problem is isolated to Outlook for Mac—a pattern also reported after Outlook updates.^1^
4. Leave Outlook open briefly if its status bar says Updating mailbox, Downloading, or Syncing. Large resynchronizations can temporarily pause Outlook; Microsoft recommends allowing two or three minutes before retrying.^2^

Since Office is already fully updated, do not repeat the update check.

2. If mail and calendar are present online, reset the Outlook account

Warning: Resetting deletes Outlook information that has not synchronized to the server. Do not proceed if recent locally created mail or calendar events are absent online.

1. Ensure the Mac is connected to the internet.
2. In Outlook, select Tools > Accounts.
3. Select the affected account.
4. At the bottom, select Manage > Reset Account.
5. Keep Outlook open while it downloads the mailbox again.
6. Recheck Load More Conversations and the missing calendar months.

This is Microsoft’s documented procedure for incomplete or incorrect Outlook data caused by a local cache synchronization problem.^3^

If Reset Account is unavailable and this is an Exchange account, use the folder-level method instead:

1. Control-click the affected Exchange folder.
2. Select Properties.
3. On General, select Empty Cache.
4. Allow Outlook to download the folder again.^4^

For missing calendar data across many months, prefer the account reset rather than clearing only Inbox.

If the events are also missing in webmail, do not reset the account as a recovery method; a cache reset can only download what remains on the server. Contact the mailbox provider or, in Outlook, select Help > Contact Support.^5^

3. Open the Excel files from their actual location

If “latest spreadsheets” means entries under Excel’s Recent list no longer open, locate the files directly rather than relying on those shortcuts.

For files saved in OneDrive on macOS 12.1 or later:

1. Open Finder.
2. Browse to Library > Cloud Storage > OneDrive, or select the OneDrive alias in Finder.
3. Open the workbook directly from that folder.
4. In Excel, use File > Save As and choose the current OneDrive location if AutoSave no longer works.

OneDrive’s Mac folder location changed, so old pinned or Recent entries can point to paths that no longer exist even though the files remain available.^6^

Also select the OneDrive cloud icon and View online. If the spreadsheets open online but are absent in Finder, the issue is OneDrive synchronization rather than Excel file loss.^7^

4. Recover an unsaved Excel workbook if necessary

If a workbook was never saved or Excel closed unexpectedly:

1. Open Finder.
2. Select Go > Go to Folder, or press Shift+Command+G.
3. Enter:

~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft

4. Look for an AutoRecovered copy, open it, and immediately save it under a new name.

AutoRecover is intended for unexpected shutdowns; it is not a substitute for files that were saved elsewhere. Selecting Don’t Save when closing removes the recovery copy.^8^

Avoid reinstalling Outlook or unlinking OneDrive until the online copies have been confirmed. Reinstallation should come later and only after verifying that important mailbox data is synchronized with the server.^2^

References

1. Outlook work account lost half amount of mails after update - Microsoft Q&A
2. Outlook for Mac not responding, hangs, freezes, or stops working | Microsoft Support
3. Clear the cache in Outlook for Mac | Microsoft Support
4. Clear the cache to solve sync issues in Outlook for Mac | Microsoft Support
5. Outlook for Mac | Microsoft Support
6. Missing files and autosave issues with OneDrive on macOS | Microsoft Support
7. Fix OneDrive sync problems on Mac | Microsoft Support
8. Recover files in Office for Mac | Microsoft Support