excel temporary files recovery

MS office has extensive AutoSave and Auto Recovery options to recovers the data lost in various scenarios like power failure, system crash or plain human error. Though many users are not aware how to use these features, even if you haven’t enabled these features the also you can restore data from the temporary files created by the office while working on the document.

So if you are the one facing data loss situation in MS Excel? Then here is a possibility that the lost content can be recovered, as the data stored in the XLS file only becomes inaccessible not lost COMPLETELY.  Well, to recover the lost data there are many online tools available to restore entire lost excel data from the corrupted or inaccessible spreadsheet document.

Well, there are also chances to recover the data from excel temporary files. When a new file is started a temporary file is created. This is either in the windows temp directory, in “C:\ Documents and Settings\<username>\Application Data\Microsoft”. So, if the file is stored on a network drive then it will be temporarily created there.

Not happy with your MS Excel performance?
Don't Miss The BEST TOOL To FIX .xls/.xlsx Errors & Issues

The excel temporary file will have few different letters after the tilde (or squiggle line “~ ”). This is helpful in finding some lost info. These are ones, which most likely contains data that can be recovered easily.

Well, this is how to recover the lost content from the temp files in excel. However, you can also recover the data by enabling the AutoSave Option. Here follow the ways to enable it.

You may also like: 

Enable AutoSave Files Option: 


As I said in the above paragraph MS Office has provided AutoSave and Auto Recovery option to avoid the risk of data loss.  By default the feature is not enabled in excel, so you need to turn it on. In order to enable, create a copy of the excel file so that the AutoSave doesn’t overwrite the original.

Enable the AutoSave option: Navigate to the “Tools” ”Add-ins and select “Autosave”

MS excel automatically saves the temp files in the default location of “C:\ Documents and Settings\<username>\Local Settings\Temp” or “C:\Users\<username>\AppData\Local\Temp” on Windows 7/Vista.

For Office 2010 and Higher:


If you are using office 2010 suit then you must have an additional built-in to the product option known as Recover Unsaved Spreadsheets. This is very helpful to restore lost excel data. Follow the ways how to utilize it:

Step 1: Click on the file tab present at the upper left corner.

Step 2: Select Recent

Step 3: In the bottom left corner you will see Recover Unsaved Spreadsheets option

Open the Saved Drafts folder. Find your file and open it by double clicking. Then save the file.

Check the path where this file is available in Windows operating system: 

Windows 8/Windows 7/Windows Vista


Windows XP

C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Office\UnsavedFiles

This is really very helpful to restore excel data from the temporary file. If you are using Office 2010 suite then the possibility to restore data in excel temp files windows is easily done. But if in case you fails in recovering data then still there is the last option available to rescue lost excel data by making use of the third party MS Excel Repair tool.

Alternate Solution: MS Excel Repair Tool


MS Excel Repair Tool is a special tool which is specifically designed to repair such kind of files so that one can easily continue to work in that file. This repair tool searches for .xls file in the folder specified by the user. The file which is found to be corrupted will create a preview in the Excel Repair window. The interface is very simple, with a large toolbar of buttons to add files or folder to the application. With this software, you can repair your corrupted excel file. It can easily restore all corrupt excel file and also recover everything which includes cell comments, charts, worksheet properties and other related data. The corrupted excel file can be restored to a new blank excel file. It has the ability to recover the complete data from the file and restore them even without modifying original formatting.



Steps to Utilize MS Excel Repair Tool:




We have tried our best to provide the ample information about recovering lost content from Excel temporary files. Hope, this will help you to fix the excel data loss situation as well as enable the AutoSave option to prevent further issues to data loss by restoring data easily.

That’s it!!!


How To Recover Lost Content From Excel Temp Files?
Article Name
How To Recover Lost Content From Excel Temp Files?
Recover lost content from Excel temporary files with the AutoSave and Auto Recovery option. Follow the steps given here….
Publisher Name
Repair MS Excel
Publisher Logo

7803 Total Views 54 Views Today

How To Recover Lost Content From Excel Temp Files?