ThisCalculator

Everyday

Excel File Disappeared on Mac? Fixes That Work

Updated · Standard formula, shown below

Excel File Disappeared on Mac? Fixes That Work

If an Excel file has vanished from your Mac, it is usually still on the drive—either moved, hidden, or open in a window you cannot see. This guide covers the most common causes and the exact steps to find and recover the file, including using Finder, AutoRecover, and Time Machine.

Why Excel Files Disappear on Mac

Files rarely get deleted on their own. More often, one of these things happened:

  • The file was saved to iCloud Drive and is not downloaded locally (shows a cloud icon in Finder).
  • You opened it from a recent list and the actual file is in a different folder than you remember.
  • The file is hidden because of a macOS update or a sync conflict (e.g., “filename (1).xlsx�).
  • Excel crashed before you saved, and the unsaved changes are in AutoRecover.
  • You accidentally moved it into a subfolder or another volume (like an external drive).

macOS does not silently delete user files during normal operation, so a search is usually successful.

First Steps: Search and Check Recent Items

Start with the fastest methods before digging into recovery tools.

  1. Press Command + Space to open Spotlight, type the file name (or part of it), and press Return. If the file appears, note its location in the search result.
  2. Open Finder and press Command + F to start a search. Set the search scope to “This Mac� and use “Name contains� for the file name. Add a second condition “Kind is Excel� if you remember the extension.
  3. Check Excel’s File menu > Open Recent. If the file is listed, hover over it—the full path is shown at the bottom of the menu. It may point to a folder you didn’t expect.
  4. Look in Trash (in the Dock). If the file is there, right-click it and choose “Put Back�.

If none of these find it, proceed to the next sections.

Check iCloud Drive and Optimized Storage

If you use iCloud Drive, your file might be stored in the cloud but not on your Mac. In Finder, go to iCloud Drive (in the sidebar) and look for the file. If it has a small cloud-with-downward-arrow icon, double-click it to download it locally.

Also check if you have “Optimize Mac Storage� enabled (System Settings > Apple ID > iCloud > iCloud Drive > Options). This setting automatically removes local copies of files you haven’t used recently to save space. The file is still in iCloud, but it won’t appear in Spotlight until you download it.

If you don’t use iCloud, skip to the next section.

Use Excel’s AutoRecover and Unsaved Workbooks

Excel for Mac has a built-in recovery feature that saves temporary versions of open workbooks every few minutes. If Excel crashed or you closed without saving, you can often recover the data.

  1. Open Excel and go to File > Open.
  2. Scroll to the bottom of the Open dialog and click Recover Unsaved Workbooks (if available).
  3. If you see your file in the list, select it and click Open.
  4. If not, go to the AutoRecover folder manually. In Finder, press Command + Shift + G and type: ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery (for older versions) or ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/AutoRecovery (for newer versions). Look for files with .xlsx or .tmp extensions.

Note: AutoRecover only works if the file was open in Excel at some point. It does not recover files that were never opened.

Recover an Older Version with Time Machine

Time Machine is the most reliable way to get back a file that was deleted or overwritten. If you have a Time Machine backup, follow these steps:

  1. Open the folder where the file used to be (for example, Documents).
  2. Launch Time Machine from the menu bar (or System Settings > Time Machine > Enter Time Machine).
  3. Use the timeline on the right to go back to a date before the file disappeared.
  4. Find the file in the Finder window, select it, and click Restore.

If you don’t have Time Machine, check if you have any other backup service (like Backblaze or Carbonite) that might have a copy.

Check for Hidden Files and Sync Conflicts

Sometimes a file is hidden because of a sync conflict or a macOS glitch. To see hidden files in Finder, press Command + Shift + . (period) while in a folder. This toggles hidden files on and off. Look for files with names like “filename (1).xlsx� or “.filename.xlsx� (the dot at the beginning makes it hidden).

Also check the Library folder for any Excel temp files. In Finder, press Command + Shift + G and type ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/ and look for a folder called “Office 2011 AutoRecovery� or “AutoRecovery�.

What to Do If You Still Can’t Find It

If the file is truly gone and you have no backup, your options are limited. You can try a data recovery tool that scans the raw disk for deleted files, but success is not guaranteed and can be expensive. Before that, double-check the following:

  • Search the entire Mac, not just your home folder—use Finder search with “This Mac� as the scope.
  • Check other user accounts on the Mac (if you have multiple accounts, log into each and search).
  • Check external drives and network volumes—the file might have been saved to a USB drive or a server.
  • Look in the Recently Deleted folder in iCloud.com (if you use iCloud Drive).

If you suspect the file was deleted by a sync error, check the sync service’s website (e.g., iCloud.com, OneDrive.com) for a trash or version history feature.

Frequently Asked Questions

Why did my Excel file disappear after a macOS update?

macOS updates can sometimes cause files to be moved to a “Relocated Items� folder in the Shared folder (if the update found compatibility issues). Check /Users/Shared/Relocated Items for your file. Also, if you had the file open during the update, it might have been saved as a temporary file in the AutoRecovery folder.

Can I recover an Excel file that was never saved?

Yes, if Excel was open and you had AutoRecover enabled. Go to File > Open > Recover Unsaved Workbooks. If that doesn’t work, look in the AutoRecovery folder mentioned earlier. If you never opened the file in Excel, there is no way to recover it—it was never written to disk.

How do I prevent Excel files from disappearing in the future?

Enable AutoSave (if you use OneDrive or SharePoint), turn on Time Machine, and make sure iCloud Drive is set to “Download and Keep� for important folders. Also, always save files to a local folder (like Documents) rather than only in the cloud.

What is the difference between AutoRecover and AutoSave?

AutoSave is a feature that continuously saves your file to OneDrive or SharePoint as you work. AutoRecover is a local backup that saves a copy of the file every few minutes in case Excel crashes. AutoSave requires the file to be stored in a cloud location; AutoRecover works for any file.

If I see a cloud icon next to my file, is it still on my Mac?

No, the cloud icon means the file is only in iCloud Drive and not downloaded to your Mac. You need to double-click it to download it. Until then, it won’t be available offline and may not show up in searches.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.