How to recover lost Excel files. - Powered By Kayako eSupport

06 Sep 2010

Support Center » Knowledgebase » How to recover lost Excel files.

	How to recover lost Excel files.

Solution How to recover lost Excel files.

Microsoft’s way:
http://support.microsoft.com/kb/324521/

1. Click Start, and then click Search.
2. In the Search Results window, click All files and folders.
3. In the All or part of the file name dialog box, type *.xls.
4. Under Type of file, expand More advanced options, and then click All Files and Folders.
5. Click to select both the Search system folders, and the Search hidden files and folders check boxes, and then click Search.

Enable AutoSave
http://www.amset.info/tips/office-recovery.asp (and the Helpdesk)…

Excel doesn't have the AutoSave feature enabled as default, you have to add it. This is because it isn't always practical to have this functionality enabled. You most likely have to manually enable the AutoSave feature, you will find the settings under "Save" where you can also disable the Auto Recover feature for that particular work book.
Excel automatically saves every 10 minutes to the default location of "C:\ Documents and Settings\\Local Settings\Temp" The files are identifiable as they are saved as a number .tmp e.g. "28.tmp". This means that they look different from word or any other temporary files that are being saved there by other applications.

Consider AutoBackup?
http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadID=229333&messageID=2280147

Excel does not have a temporary backup function like Word does.
AutoSave in Excel will save your work automatically. The catch is it overwrites your original file.
Your only other option is to always save a backup copy of your work by doing the following (from Excel help)...
- On the File menu, click Save As.
- On the Tools menu, click General Options.
- Select the Always create backup check box.
- Click OK, and then click Save.

Article Details

Article ID:

Created On:

08 May 2009 06:17 PM