How to Recover Deleted or Inaccessible Excel Workbooks on Mac
Question details
The user is trying to find and recover missing Excel files that appear as deleted or inaccessible in the recent files list.

- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Attempting to open recently accessed Excel workbooks after modifying system storage, such as deleting unfamiliar macOS user profiles to free up disk space.
- Observed behavior
- Excel displays the files as deleted or inaccessible from the recent list. Standard Finder and Spotlight searches fail to locate them on the drive, although Excel's internal search intermittently recognizes them.
Stop saving new files or downloading large applications to your Mac immediately to prevent overwriting any potentially recoverable Excel data, and connect your backup drive if you use Time Machine.
Locate Missing Files via Trash, Cloud, and Spotlight Deep Search
Often, files are accidentally moved to the Trash, synced to a cloud folder, or relocated. A comprehensive system search is the most effective first step.
Before assuming the files are permanently deleted, verify that they haven't been shifted to a different directory or removed from local storage by a cloud syncing service.
Click the Trash icon on your Mac Dock. Use the search bar in the top right of the Trash window to look for your Excel file. If found, right-click the file and select 'Put Back'.
Press Command + Space to open Spotlight Search. Type the exact name of your workbook or type 'kind:excel' to list all Excel files on your Mac.
Open Finder and check the iCloud Drive, OneDrive, or Dropbox folders in the sidebar. Sometimes, macOS offloads local files to the cloud to save space, making them appear inaccessible locally.

Restore the Excel Workbook Using Time Machine
If the file was permanently deleted or lost during user profile removal, Apple's Time Machine can revert your folders to a previous state.
Check Disk Health with Disk Utility
If Spotlight and Excel behave inconsistently (e.g., one finds it but the other doesn't), there may be underlying file-system errors on your startup volume.
Try WPS Office for Reliable Spreadsheet Management
If you are frustrated by missing files, inaccessible workbooks, or expensive subscriptions in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for Mac users, complete with robust built-in backup features to safeguard your data.

Frequently Asked Questions
Why does my Excel file show as inaccessible in the recent list?
The 'Recent' list in Excel is just a collection of shortcuts to the original file locations. If the file was deleted, moved to a different folder, or stored on an external drive that is currently disconnected, the shortcut breaks and Excel displays an inaccessible error.
Can I recover an Excel file if I deleted the Mac user profile it was saved in?
Yes, if you selected the macOS option to 'Save the home folder in a disk image' when deleting the user account, you can find that image in the 'Deleted Users' folder under your Mac's 'Users' directory. Double-click the image to mount it and retrieve your files.
How do I find hidden temporary Excel files on Mac?
You can check the hidden Mac temporary folder by opening the Terminal application and typing 'open $TMPDIR'. Look for a folder named 'TemporaryItems', which may contain cached or auto-saved versions of your missing workbooks.
Does Excel for Mac have an AutoRecover folder?
Yes, Excel for Mac automatically saves backup copies if AutoRecover is enabled. To find them, open Finder, hold down the Option key, click the 'Go' menu, select 'Library', and navigate to Containers > com.microsoft.Excel > Data > Library > Preferences > AutoRecovery.




