Advice 1: How to recover an unsaved Excel file

At times the users of personal computers rashly close open documents, forgetting to save the file. Thus the lost files can still be recovered if in the program settings, emphasis was placed on some options.
How to recover an unsaved Excel file
You will need
  • Software Microsoft Excel 2010.
Instruction
1
In recent versions it has become possible to recover a lost document from any copies stored in the system files using the equation editor. It is necessary to assign a couple of options in the settings: "auto save every... minutes" and "keep the last version". After you select the number of minutes after which you want to save the document, press Enter to close the window.
2
If these actions were performed by you prior to the loss of the file you want to recover the document when you restart the program. In the main window, running utilities vklade go to "File" and click "Recent files". Click the left mouse button on the link "Recover unsaved book".
3
In the opened window you will see the contents of the directory with the drafts saved until this moment. Select one of the recent files and click the Open button. Now left click Ctrl + S or click "Save as" on the top bar.
4
Also, this file can be opened in another way. In the main program window click Open and run any file. Then go to the File tab and click Info.
5
Click "Manage versions" and then click "Recover unsaved workbooks". From the list, select one of the recent files and click "Open".
6
Lost, the file can always be found in one of the following ways: C:\Users\_имя_учетной_записи_пользователя_\AppData\Local\Microsoft\Office\UnsavedFiles (for Windows Vista and Windows 7) and
C:\Documents and Settings\_имя_учетной_записи_пользователя_\Local Settings\Application Data\Microsoft\Office\UnsavedFiles.
7
It is worth noting that the temporary files stored in these directories is not more than 4 days, so you need time to restore them or copy to another directory.

Advice 2: How to restore excel file

No user is protected from accidentally deleting important files. Fortunately, there are programs that allow you to quickly recover the lost during formatting or deletion of data.
How to restore excel file
Instruction
1
If we are talking about files created using the program Microsoft Excel, then use the utility Easy Recovery. Download this program and install it. To ensure the best quality recovery information, use the Pro-version of the utility.
2
Run the program previously re-booting. In the opened quick launch menu, click Data Recovery. In the new window, select Deleted Recovery. Select the hard disk partition which was deleted Excel file by clicking on its graphic image in the left column of the new menu.
3
Specify the file type. Choose from templates Office Documents. Activate Complete Scan (full search) by setting the checkbox next to the appropriate label. Click the Next button. Wait until the program scans for deleted files and will complete the preliminary preparation for the restoration.
4
Note that this process may take several hours, if you are using a relatively old computer with a hard disk of great volume. In the left column of the new menu will be a list of files ready to restore. Find the information you need and highlight them all off.
5
Click Next and select the folder you want to save the files. Wait until the operation completes. Now go back to the main menu and open the menu File Repair. Go to Excel Repair and specify the folder to which you restored your files.
6
Wait until the process of correcting the errors of these tables. Please note that documents of this kind is relatively difficult to restore. This means that you need to carefully check the quality of the output file before using it. Some files may be partially restored. Try not to use the PC after deleting important data.
Is the advice useful?
Search