Where Excel Stores Files You Can Still Reach

If you closed an Excel file without saving, deleted it by mistake, or your computer crashed, you have several places to look before assuming the file is gone. Excel keeps temporary copies, Windows keeps deleted files in a staging area, and cloud services keep version history. The fastest recovery route depends on what happened and when.

Start by checking whether the file still exists somewhere on your computer. Open File Explorer (Windows) or Finder (Mac), navigate to the folder where you normally save spreadsheets, and look for the filename. If you cannot remember the folder, use the search box to search for .xlsx or .xls files modified on the date you were working on it. This catches files you may have saved to an unexpected location.

Key Takeaways

  • Check your Recycle Bin (Windows) or Trash (Mac) first — deleted files sit there until you empty it, and recovery takes seconds.
  • Excel's AutoRecover feature saves temporary copies every 10 minutes by default, stored in a separate folder you can browse without opening Excel.
  • If you used OneDrive, Google Drive, or Dropbox, the file version history may hold older copies you can restore with a few clicks.
  • Windows File History and Mac Time Machine can recover files from backup snapshots if you set them up before the loss happened.
  • Data recovery software can retrieve files from a deleted folder, but only if you have not written new data to that disk space since deletion.

Recovering from Recycle Bin or Trash

If you deleted the file intentionally or by accident, check your Recycle Bin (Windows) or Trash (Mac) before trying anything else. Files stay there until you empty the bin, which means recovery is usually straightforward.

On Windows: Double-click the Recycle Bin icon on your desktop. Scroll through the list to find your Excel file by name or by the date it was deleted. Right-click the file and select Restore. The file returns to its original folder.

On Mac: Click the Trash icon in the Dock (usually at the bottom right of your screen). Find your file in the list. Right-click it and select Put Back. The file returns to the folder it came from.

If you already emptied the Recycle Bin or Trash, move to the next section. Once you empty it, the file is no longer in that staging area, though recovery may still be possible through other methods.

Finding AutoRecover Temporary Files

Excel automatically saves a temporary copy of your work every 10 minutes (the default interval). If your file closed unexpectedly or you did not save before closing, this temporary version may be your best option. These files are stored separately from your normal documents folder.

On Windows: Open Excel and go to File > Info > Manage Versions (or Recover Unsaved Documents depending on your Excel version). A window opens showing unsaved files. Click the file you want and select Open. If nothing appears there, manually navigate to C:\Users\[YourUsername]\AppData\Local\Microsoft\Office\UnsavedFiles. You may need to show hidden files: in File Explorer, go to View > Show hidden files.

On Mac: Open Excel and go to File > Open Recent > Recover Unsaved Workbooks. A dialog shows unsaved versions. Select the file and click Open. If that option does not appear, the temporary files folder is at ~/Library/Containers/com.microsoft.Excel/Data/Library/Autosave Information. Use Finder's Go menu to navigate there.

Temporary files are named with timestamps and may not show the original filename. Open each one to check its contents. Once you find the right version, save it with your original filename in your normal documents folder.

Restoring from Cloud Storage Version History

If you saved your Excel file to OneDrive, Google Drive, Dropbox, or another cloud service, those platforms keep version history. You can roll back to an earlier copy without needing to recover anything from your computer.

OneDrive: Go to onedrive.com, find the file, right-click it, and select Version history. A list of saved versions appears with timestamps. Click the version you want and select Restore. The file reverts to that point.

Google Drive: Right-click the file, select Version history > See all versions. Click the version you want, then click the three-dot menu and select Restore this version.

Dropbox: Right-click the file on dropbox.com, select Version history, and click the version you want to restore. Select Restore.

Version history typically goes back 30 days for free accounts and longer for paid plans. If your file was deleted weeks ago, this method may not work, but it is worth checking first because it is the fastest recovery route when it is available.

Using Windows File History or Mac Time Machine

If you set up File History (Windows) or Time Machine (Mac) before the file was lost, you can recover it from a backup snapshot. These tools take regular backups of your entire system, including deleted files.

On Windows: Plug in the external drive where your File History backups are stored. Open File Explorer, navigate to the folder where your Excel file should be, and right-click in the empty space. Select Restore previous versions. A list of backup dates appears. Click the date closest to when your file was last saved, and click Restore. The file returns to that folder.

On Mac: Click the Time Machine icon in the menu bar (top right) and select Enter Time Machine. Use the timeline on the right to navigate to the date your file existed. When you find it, click the file and select Restore. The file returns to its original location.

File History and Time Machine only work if you set them up before the loss happened. If you have never used either tool, you cannot recover from them. However, if you set them up now, they will protect future files.

Data Recovery Software as a Last Resort

If none of the above methods work, data recovery software can sometimes retrieve deleted files from your hard drive. These tools scan your disk for file fragments and attempt to reconstruct them. This method works only if you have not written large amounts of new data to your disk since deletion — new data can overwrite the space where your file was stored.

Common data recovery tools include Recuva (Windows, free), EaseUS Data Recovery Wizard (Windows and Mac, free version available), and DiskDrill (Windows and Mac, paid). read the tool on a different computer if possible, or use a USB drive to run it, to avoid writing new data to the disk you are recovering from.

Install the software, select the drive or folder to scan, and let it run. The scan can take hours depending on disk size. When it finishes, look for your Excel file in the results. Right-click it and select Recover, then choose a safe location to save it — never save it back to the same disk you are recovering from.

Data recovery software is not may provide to work, especially if the file was deleted weeks ago or if you have used your computer heavily since deletion. It is also slower and more complicated than the other methods. Use it only when the file is not in your Recycle Bin, AutoRecover, version history, or backups.

Preventing Future Loss

Once you recover your file, set up protection so you do not lose work this way again. Enable AutoRecover in Excel: go to File > Options (Windows) or Excel > Preferences (Mac), find AutoRecover, and make sure it is turned on. The default 10-minute interval is reasonable for most work.

Save your Excel files to a cloud service like OneDrive, Google Drive, or Dropbox. These services keep version history automatically and protect against both accidental deletion and hardware failure. If you prefer local storage, set up File History (Windows) or Time Machine (Mac) with an external drive. Both run automatically once configured and require no ongoing effort.

Frequently Asked Questions

Can I recover an Excel file if I never saved it?

Yes, if Excel closed unexpectedly. Check AutoRecover through File > Info > Manage Versions (Windows) or File > Open Recent > Recover Unsaved Workbooks (Mac). Excel saves temporary copies every 10 minutes by default, even if you never manually saved the file.

How long does version history stay available on cloud services?

OneDrive and Google Drive keep version history for 30 days on free accounts. Dropbox keeps it for 30 days as well. Paid plans often extend this to 180 days or longer. Check your service's settings to see your specific retention period.

Will data recovery software work if I deleted the file months ago?

Probably not. Data recovery works best when deletion is recent and you have not used your computer much since. The longer you wait and the more you use your disk, the more likely new data has overwritten the space where your file was stored, making recovery impossible.

What if the file was on a shared drive at work?

Contact your IT department or network administrator. Shared drives usually have their own backup systems separate from your computer. They may be able to restore the file from a server backup even if it is gone from your local copy.

Can I recover an Excel file from a computer that will not turn on?

Not directly from that computer. You would need to remove the hard drive and connect it to another computer using a USB adapter, then use data recovery software or check for backups. If the drive is physically damaged, a professional data recovery service may be necessary, though this is expensive and not always successful.