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.

Advice 3: 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 4: How to open Excel file with password

To open a protected password file Excel is impossible without the involvement of additional third-party software developers. Such programs, there are many, and choosing the most appropriate is up to the user.
How to open Excel file with password
You will need
  • - Pasword Remover;
  • - Advanced VBA Password Recovery;
  • - Excel Password Recovery Master.
Instruction
1
Boot the app Passord Remover Einar Huse Stele created, to perform the operation of opening the fileand protected Excel password, and run the executable file password.xla.
2
Click OK in the message about the successful installation of the program and expand the tools menu of the top toolbar of the Excel application window included in the package of Microsoft Office.
3
Find new items Unprotect Sheet and Unprotect Workbook are designed to perform the required operations removing the password from selected file.
4
Select the desired worksheet or workbook, and use the corresponding menu command "Service".
5
Take advantage of the free demo app Advanced VBA Password recovery offered by company Elmsoft, to remove the password of VBA scripts in office Excel.
6
Run the program and select Open File in the top toolbar of the application window.
7
Specify the filesubject to discovery in the list and select the desired action in the dialog box VBA Password.
8
Click Change Password to change the password of the selected fileand or click the Delete Password to remove the password.
9
Click OK to confirm the selected changes.
10
Rate the features of the program Excel password Recovery Master from Rixler Software, integrating the on-line key search on the company server with the actual process of decoding that is performed on the local computer that provides maximum protection of sensitive user data, always remaining on the computer. The app interface is intuitive and requires no special training. The procedure of decryption and a password reset is performed in the background, and the operation can be carried out with one mouse click.
Note
All of the above programs are designed to recover the lost password of the user and should not be used to crack passwords!

Advice 5: How to reduce Excel file

Quite often users of the program Microsoft Excel ask why the file with a small table sometimes takes about 5-10 MB. So happens for a reason, a set of formulas over time, make the file heavy, reduce which can be difficult.
How to reduce Excel file
You will need
  • Software Microsoft Excel.
Instruction
1
The very first and the main reason for the large volume of the table is shared. What does it mean? For example, office computers United by one network, there is a table that is used by all users of the network. The program itself assigns the filefrom multiple users and provides information about how much and by whom was the document changed. Not hard to imagine that when the number of users in excess of 2-3 people, size of fileand is getting huge.
2
For versions of MS Excel 2003 and older you need to click the top menu "Tools" and select "share workbook". For versions, the 2007 and younger must in the main program window go to the tab "Review" and select "share workbook". In the opened window, in both cases, go to the tab "Details".
3
Check the box next to "do Not keep history of changes", and save the open table. Now you need to set the number of days during which the log will be stored. Opposite this option, you will see the figure of 30, but can be done much less.
4
You can then remove rows and columns that you do not use. How do you know? Go to the table and press Ctrl + End. The cursor in the document will automatically move to the last cell of your table. Look above and to the right of this cell you the unused rows and columns. If so, select them and delete, thereby reducing the total number of cells.
5
It is also recommended to get rid of the formatting you don't use often. Color white stakes in the transparent cell is the best replacement for "No fill." For offline disable formatting of cells select them, then click the top menu "edit", select "Clear", command "Format" (Excel 2003) or open the Home tab, choose block "Clear", "Clear formats".

Advice 6: How to reduce size of Excel file

The task of reducing the size of the file Microsoft Excel is one of the most frequently discussed in various forums. There are several practical solutions that do not require special training and additional software.
How to reduce size of Excel file
Instruction
1
Help menu the Microsoft Windows operating system by pressing the "start" button and click "All programs" to perform the procedures necessary to reduce the size of Excel files.
2
Point to Microsoft Office, and run the Excel application.
3
Open to edit the book and open the tools menu of the top toolbar of the application window in Microsoft Excel 2003 or go to the 'Review' tab in Excel 2007.
4
Select "share workbook" and apply the check box on the "do Not keep history of changes."
5
Save the selected change and select the desired time interval (default is 30 days).
6
Make sure that you are using a standard font - Arial Cyr for Excel 2003 or Corbel for Excel 2007 and please remove the extra conditional formatting. To do this, highlight the range and expand the menu "edit" of the top toolbar in Excel 2003 or click on the Home tab in Excel 2007.
7
Enter the command "Clear" and select "Format" for Excel 2003 or the "Clear formats" to Excel 2007.
8
Optimize used formulas and minimize them - use "or" instead of "IF" and "EOS" instead of "ELISHEBA".
9
Use the macros that allow you to convert formulas to values after the command "Recalculate" to reduce the number of formulas, columns and rows and refrain from using formatting entire sheet of paper.
10
Try not to use graphs and charts, replacing them with the drawings and select the option "No fill" instead of "Fill white".
11
Try not to use names in the tables (to display the names in the book weed simultaneously pressing function keys Ctrl+F3) and select the version of Microsoft Excel 2007. The file sizes are reduced on average two and a half times.

Advice 7: How to recover lost documents

Documents are issued to the person from birth. All his life he gets a new, use them until the end of his days. In case of loss of passport, professional ID cards, badges in various manufacturing and operating facilities, certificate of completion of educational institutions, the right to drive a car, birth certificate and others for a short time to recover the paper.
How to recover lost documents
Instruction
1
Contact the police if you lost your passport. You will be given a certificate of a certain form, indicating the reason for the loss of the identity document. Go to the housing office at your place of registration (residence permit) with this certificate and complete the application, the passport will issue a notification of missing passports. Residents of the private sector, such a document gives the quarterly. Visit the passport office where the complete application on a form reissuance of passport. Pre-take a photo and submit to the institution 4 photos for passport. Pay the state fee in any branch of the Bank. The size will be 200 rubles. Within 30 days you will be issued a new passport.
2
Go to the registry office at the place of residence, if you have lost your marriage certificate. Write an application, attach a photocopy of your passport and identity document of the spouse, do not forget to take the originals. You will have to pay a state fee of 400 rubles each at any Bank branch and attach the documents receipt. The duplicate with the corresponding mark you will get in one day. The same procedure must pass, if we are talking about restoring birth certificate or death.
3
Restore a driver's license as soon as possible after the loss. Grab your passport; you will also need a medical certificate about state of health, one photo of size 3.5 x 4.5 inches, receipt about payment of state duty. Take the documents to the traffic police, where you will write in your name, temporary ID, and then have to pass the driving test. Within 30 days will issue a new document.
4
Lost military ID card, contact the branch recruiting office, write a statement about the loss, we will state in it the circumstances under which the loss occurred. Submit photos of the established sample and wait for the issuance of a duplicate. It is usually given at once.
5
Keep the certificate of ownership of real estate very carefully. Legal documents can be restored to the Registration chamber at the place of residence. You will need to write a statement about the loss. It happens when the documents are losing at the stage of the transaction. Contact the notary who had notarized and provided the necessary information. Usually he has a copy, and he will be able to compensate for the loss. If you fail, go to court. On the basis of the court decision of Registration chamber will issue a new certificate of title on the property.
Note
Almost every lost document can be recovered within a month at the place of issuance of the initial instance.
Useful advice
Submit to a local newspaper ad with the words "be void" any document you have lost.

Advice 8: How to recover an unsaved document

The solution to the problem of recover unsaved document can be conventionally divided into two methods depending on whether the document is accidentally closed by the user, or an unexpected shutdown office application.
How to recover an unsaved document
You will need
  • Microsoft Office 2010.
Instruction
1
If there is an unexpected exit of office apps included in Microsoft Office Suite version 2010, then wait until the task pane "document Recovery". In this area it is possible to save up to three files, recovery which can be performed by the user.
2
Open the link with an arrowhead symbol, located next to the document in the window of the restore, and specify the desired action:- "Open" - to view the latest version of the document;- Save as - to change the name or version of the desired file; - Remove - cleaning the recovered documents.Save the recovered document.
3
If you accidentally close the document by the user without saving, call the main menu by pressing the "start" button and navigate to "All programs." Expand Microsoft Office 2010 and run the application where you created the private file.
4
Open the menu "File" the service window panel for the selected application, and then click "Recent files". Specify the paragraph:- "Recover unsaved documents" - files created in Word;- "Recover unsaved workbooks" for files created in Excel;- "Recover unsaved presentations" - for files created in PowerPoint.
5
Find you want to restore a document in the directory dialog that appears, and click "Open". Save the recovered file using "Save as" upper service panel of Windows office applications.
6
An alternative method is to create a new document in the desired office application. Then open the menu "File" and select "Information". Click the "Manage versions" and select one of the above commands in accordance with the used application. Browse for the document in the directory and click "Open". Save the recovered file.

Advice 9: How in Excel to calculate the age

Software packages Microsoft Office Excel, Gnumeric and OpenOffice.org Calc can not only create and edit spreadsheets, but also to carry out calculations. You can, for example, to enter birth years are listed in the list of people and automatically calculate their age.
How in Excel to calculate the age
Instruction
1
Take in table one cell for the number of the current year. Type the appropriate number (always four-digit and two-digit abbreviated). In all the following examples it will be assumed that the number of the current year entered in cell A1.
2
You can also do to the current year was set automatically. Then the value of the corresponding cell can not modify manually every year, but it is correct computations will be implemented only if the computer is properly set the clock and calendar. Use the following formula: =year(today()) in the Russian version or =year(today ()) in English. In the program Gnumeric here and further use the operators in English, even if the program interface is in English.
3
In the cell where you want to be a person's age, enter the following expression: =A1-Xn, where Xn is the cell where is the number of the year of birth of the same person. For example, if it is located in cell B4, the formula will be: =A1-B4.
4
This method is inconvenient that the date of birth for all listed in the table of people accepted for the first of January, and the age is calculated without taking into account the factor that birthdays can have on the middle or the end of the year. To calculate the age more accurately, put into cell A1 the current date in the format configured for the used office package (these settings can be changed). For example, if the date format is DD/mm/yyyy and today 6 April 2012, enter into this cell 06/04/2012. Note that in this case, to change the contents of the cell will have to manually every day. To avoid this, enter the expression: =today() or =today(). In this case, as in the previous case, make sure that you correctly set the clock and calendar.
5
Instead of the year of birth of the person specify in the corresponding cell and his date of birth in the format in which configured office Suite. And in the cell that must be specified is automatically calculated age, enter the following expression: =datedif(A1;Xn;"y") or =Rashat(A1;Xn;"y"). For example: =datedif(A1;B4;"y"). The letter y is in both cases Latin.

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

Advice 11: Why not open the excel file

Spreadsheets created in Microsoft Excel of different versions, have a number of properties, which open files can be difficult. It is necessary to understand why not open the file in Excel.
Why not open the excel file

Compatibility issues


Most often, the problems with opening the files created in Excel, due to the fact that they were created in different versions of the program. If the file was made in Excel 2007, 2010 and 2013, it is unlikely to be properly opened in older versions of the program. The problem can be solved by installing a special patch created specifically to solve these compatibility issues. It's called "compatibility Pack Microsoft Office for file formats Word, Excel, and PowerPoint 2007". Let the name and the figure sounds 2007, but the difference between the files created in Excel 2010 and 2013 there, so this patch is suitable for solving problems with opening files.
There is a free program that functionality is not inferior to Microsoft Office and in particular Excel Microsfot. It's called OpenOffice.


If you install this patch for Excel 2003 is not possible, you can ask to re-save this file from the new format ("xlsx") in the older (xls). In order to do this, Microsoft Excel 2007, 2010 or 201 you should click "File" then click on "Save as", then choose from the offered formats is required.

Formula and editing


Microsoft Excel 2007, 2010 and 2013 have a number of significant advantages over older versions. First, is the protection of cyclic formulas. It is a logical fallacy, in which the loop is embedded in the formula will be endlessly repeated. In older versions of Excel, this formula could lead to data loss and system lockup at all. More recent versions of the product from Microsoft may block the occurrence of similar formulas, such files cannot be opened in Excel later. If the file to open need, you will have to ask the Creator to remove all cyclic formula from a file.

The file created in newer versions of Excel may not correctly open only when there is a special patch, but with the support of all the fonts with which to create the file. Otherwise, you will have to learn their names and to download from Microsoft official website.
It is worth saying that in Microsoft Excel 2007,2010 and 2013, there are formulas that will not be supported in older versions. Such a file may be opened in them, but the formulas will work not all.


The programs that create files for Excel


At the moment the option of saving the file in xls and xlsx formats offers a variety of programs. Some do it worse, some better. For example, the famous FineReader program is able to scan files directly in Excel format in pretty good quality. These files will be safely opened in any version of Microsoft Excel. But there are many other programs that are not able to do it with the same quality. It can be as analogues FineReader and program, specializing in converting files from format to format. Files created in these programs can be opened in Microsoft Excel with good quality.
Is the advice useful?
Search