Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

Recover Unsaved Excel file

Recover Unsaved Excel file

In this tutorial, I want to show beginners in Excel, so they can recover unsaved file. So in layman's terms, how can you restore or recover a file that you have not saved.

The situation is as follows: You start Excel, and do various tasks and calculations in the file to multiple worksheets. You have not saved workbook. For some reason, Excel crashed or blocked. You're sorry because you need to restart your computer or Excel program and you have not saved the data or changes in an existing workbook.

Configuring AutoSave (AutoRecover) settings in Excel

In the beginning, my advice is to configure Excel to automatically save and store all your actions or changes in existing or new workbook.

Click on File => Excel Options => Save menu

In the settings 'save Workbooks' set after how many minutes you want to save the workbook "Save AutoRecover information every"

You turn on (check) "Keep the last autosaved version if I close without saving" (see figure below)

Figure 1.
Save data every X minutes - AutoRecover in Excel

Advice:

Be sure when you start a new Workbook, immediately do the saving and archiving Workbook. Auto Recover feature is useful only if you archive the workbook at least once.

How to recover unsaved Excel workbooks or files

Take for example that you open an existing or a new workbook. You did change within a spreadsheet and enter data in the time period 10-15 minutes. You have not saved or archived respective workbook. Gone was the electricity, your computer is restarted for some reason and re-launched. You absolutely miserable, complaining about the loss of data that you entered in the workbook.

Do not despair! If you have set the settings as in the previous step, ie. If you configure the Auto Recover and Auto Save then you have a chance to recover and save the data that you think that you have lost.
  • Start Excel program
  • Click on File => Open
  • Click the Recent Workbooks
  • Click the Recover Unsaved Workbooks
Figure 2.
Recovering unsaved files in Excel
Or do the following
  • Click on File => File => Manage Version
  • Close the drop-down menu and click "Recover Unsaved Workbooks"
Figure 3.
Recover Unsaved Workbooks - Manage Workbooks

Summary:
  • So, you opened an existing or new Workbook
  • Excel program is for some reason blocked
  • You reset the Excel program and re-start
  • You did start the procedure for the "Recover Unsaved Workbooks"
  • At the next dialog box, select Workbook that you want to save that. Recover and click the Open button.
Figure 4.
Recovering Excel workbook
After clicking on the Open button, Excel opens the recovered workbook (file). You need to click the Save As button to save the recovered file.

Figure 5.
Recovered Excel workbook - saving

And finally, you have successfully saved the recovered workbook with changes that you have made from a certain last step.
Please note that the Excel remember the last entry or change in the workbook, depending on the period of time that you set for automatic saving (AutoRecover in Excel).
See the first image of this tutorial. I put one minute for automatic saving.