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 recover an unsaved file

Often when working in Microsoft Office users for some reason forget or not have time to maintain the fileon which they just worked on, and information is lost when you close the unsaved document. If you have not saved the file and closed the program, it does not mean that all your work was lost – not saved in the Microsoft Office file you can recover.
How to recover an unsaved file
Instruction
1
To restore Office documents stipulating the function, allowing to restore a file from backup that runs regularly through periods of time while working with the fileom. Accordingly, you can run the last of the automatically saved versions of your document.
2
This function is available if your program is set to AutoSave every ... minutes". Also you need to enable the option in settings "automatically Save the latest version if the file was closed without saving".
3
Connect these functions and then if you accidentally close a file without saving, you can easily restore the latest version, stored by the program.
4
Open the Microsoft Office application in which you are not able to keep the previous file (e.g. Word or Excel) and then open the menu "File" and select the Last filey". Then select the option "Recover unsaved documents" or "Recover unsaved workbooks".
5
In Power Point the program will ask you to recover an unsaved presentation. A new window will open in which you will see auto-saved drafts. Select any file and open it and then select the menu option "Save as".
6
In addition, restore the file by choosing the menu "File" the option "Information" and then "versioning". In the opened window, click on recover unsaved documents.

Advice 3 : 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.

Advice 4 : As in Excel to recover data

While working with different documents need to be extremely careful. Pressing a few incorrect keystrokes can lead to complete clearing or deleting important files. In such situations, it is necessary to use program that allows you to recover deleted tables and text documents.
As in Excel to recover data
You will need
  • - Recovery Toolbox for Excel;
  • - Easy Recovery.
Instruction
1
To restore the integrity of the spreadsheet, use the Recovery Toolbox for Excel. Download the installation file of this application. Run the installation program. To do this, accept the license agreement and select a folder to extract the files.
2
In the last setup menu activate the Create desktop icon. Run the program with the help that appears on the desktop shortcut. Click Open and select a spreadsheet, the integrity of which needs to be restored.
3
Click the Analyze button and wait for a while until the software will scan the selected document. After this process is complete, you will be presented with a table containing all the information you managed to recover.
4
It should be noted that the described utility supports work with multi-page tables. Switch between sheets for a full assessment of the restoration quality.
5
Install the Microsoft Excel program. Without her presence, you will not be able to export recovered data on computer's hard disk. After installing the program, click the Export to Excel button located at the bottom of the work window.
6
Immediately after this, a new table is created in Microsoft Excel. Wait for it to auto-fill the information recovered with the processed file. Close the application Recovery Toolbox for Excel. Save a new spreadsheet.
7
If you completely removed the required documents, and have not changed their contents, use Easy Recovery. It should be noted that this application has a built-in function of restore spreadsheet of various sizes.
Is the advice useful?
Search