Where is Excel Recovery File Location? How to Recover Unsaved File?

Simon Marcus

2023-08-08 14:59:34

63772 views, 5 min read

After spending almost an hour filling up a spreadsheet, Microsoft Excel crashes or you forget to save it before quitting. what do you do? Don't let your anger get the best of you just yet, we've assembled all the effective methods to assist you with recovering Excel temp files in Windows 11/10/8/7, Mac and iOS. Read on!

1. The Location of Excel Temp Files in Windows 11/10/8/7

When you install any Microsoft Office package on your computer, by default the program will save temporary copies as you work. If your computer crashes, the next time you open Microsoft Excel you'll be shown the "AutoRecover" menu which lists the most recent Excel temp files.

However, if this doesn't appear or you closed Excel without saving (in which case it wouldn't show anyway), you can access all of the temp files manually. The temporary save folder is different for each Windows version:

• Windows 11/10: C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles

• Windows 8/7/Vista: C:\Users\UserName\AppData\Local\Microsoft\Office\UnsavedFiles

• Windows XP: C:\Documents and Settings\UserName\Local Settings\Application Data\Microsoft\Office\UnsavedFiles

2. How to Manually Recover Excel Temp Files

After making your way to the respective directory you'll have the answer to where is Excel temp file location and can manually recover them.

Step 1. Go to the location of Excel temp files (check the above content) and open and files.

Step 2. On the top right corner, click "File", then "Save As", pick the place where you want to save your workbook.

Some methods show how to recover unsaved Excel files with or without Excel temp files. In case that you have lost or accidentally deleted Excel files from your computer or any other storage device, you can try the following method.

Of all the solutions for getting back lost data, AnyRecover is by far the best. This is the ultimate data recovery tool and it doesn't just come in handy for recovering Microsoft Excel files. No matter what type of file or how it was lost, this program will successfully recover your data.

Features of AnyRecover:

• An all-in-one data recovery software that supports recovering data from iPhone/iPad devices, Windows, and Mac computers.
• It not only helps you recover those precious photos, but also provides the "AI photo restoration" function, which can help you fix blurry photos or repair damaged pictures/videos.
• Recover Excel files or their temp files that were corrupted, deleted, or lost from software updates.
• Recover data from any type of storage device, including computer, external hard drive, flash drive, SD card, etc.
• Support recovery of over 1000 file formats, such as photos, videos, documents, etc.
• Existing versions of files aren't overwritten during recovery, 100% safe to use.
• Support Windows 11/10/8/7, MacOS and iOS versions.

Download Now

It's clear from the features above that AnyRecover is an impressive tool. Follow the steps below to recover your unsaved Excel files with it.

Step 1. Download AnyRecover on your computer, install it, and then launch it. Choose the location where your Excel files were saved before.

Step 2. After selecting the appropriate location to scan for the temp files, then click Start. Wait while the scan takes place (it should only be a few minutes).

Step 3. Navigate through the folders on the left to find the Excel spreadsheets and once you find them, check their boxes. Finally, click Recover and your unsaved spreadsheets will be restored.

There are also options available to recover unsaved Excel files in Windows 11/10/8/7 without knowing the location of temp files.

Method 1. Restore from the Previous Version

From within Excel, you will also be able to view the previous/unsaved versions of your Excel files.

• Launch Microsoft Excel and open the most recent save you have of the Excel file.

• At the top of the window, click on File and click Info.

• Next to Manage Workbook the recent autosaves/autorecovery files are shown. Click on the one which you want to restore.

• Excel will display a preview of the file. To save it, click Restore and rename it appropriately.

• A new window will appear showing you all of the unsaved Excel files. Choose the one you want to recover and click Open.

• Save the recovered file to prevent losing it again.

If autosave isn't set up then you won't have as many versions available, but most users will find this method helpful.

Method 2. Using Recover Unsaved Workbooks

Most solutions won't require you to know where does Excel save temp files, this one included. For new files that you haven't saved even once, try using these steps.

• Open Microsoft Excel and create a new file.

• Click the File tab at the top-left corner.

• Select the Open option and click on Recent.

• At the very bottom of this list press Recover Unsaved Workbooks.

• A new window will appear showing you all of the unsaved Excel files. Choose the one you want to recover and click Open.

• Save the recovered file to prevent losing it again.

Microsoft Office is one of the few software packages which have this safety net for users. If you ever create a new workbook in Excel and didn't save it intermittently, this will help you recover it.

After reading this post, you must know where is Excel recovery file location is and how to recover unsaved Excel file. Microsoft Office is slowly becoming more advanced and as a result, includes features that create Excel temp files which minimize the risk of data loss.

If you need to recover unsaved Excel file in Windows 11/10/8/7 or macOS, there are still chances to get them back with AnyRecover.

Download AnyRecover and save your files right now before they get overwritten! Once the