MS office has AutoSave and Auto Recovery options to recover the lost Excel content, data lost. The data loss situation is faced by the users due to various reasons like power failure, system crash or human error. However, users can recover Excel lost content from temp files by enabling the AutoSave feature and AutoRecovery option. Many users are not aware how to use these features, it is possible to restore content even if you haven’t enabled these features. You can also 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 there is a possibility to recover unsaved spreadsheets, 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.
Recover Excel Lost Content From Temporary Files:
Well, the recovery of the lost content can also be done from excel temp 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 a temporary file is created there.
The Excel temporary files 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 you can recover the Excel lost content from temp files. However, you can also recover the data by enabling the AutoSave Feature. Here follow the ways to enable it.
You may also like:
- How To Recover Excel From The “Cannot Copy .Xls.” Error Message
- Fix Excel Error “Invalid XLS File Format” On Windows OS
Enable AutoSave Files Option:
As I said in the above paragraph MS Office has provided AutoSave Feature 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 the features, create a copy of the Excel file so that the AutoSave doesn’t overwrite the original.
Enable the AutoSave Feature: 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 Excel content. Follow the ways how to utilize it:
Step 1: Click on the file tab present at the upper left corner.
Step 2: Select Recent > 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
C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Office\UnsavedFiles
This is really very helpful to restore Excel content from the temporary file. If you are using Office 2010 suite then the possibility of lost content recovery in Excel temp files Windows is easily done. But if in case you fail in recovering lost content 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 any sort of issues, corruption, errors in Excel file. This can also easily restore entire lost Excel data including cell comments, charts, worksheet properties and other related data. It is a unique tool that can repair multiple corrupted Excel file at one repair cycle and restore data to a new blank Excel file or preferred location. The tool has the ability to recover data without modifying the original formatting. It is easy to use.
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. And also enable the AutoSave option to prevent further issues to data loss by restoring data easily.