Recover Unsaved Excel Workbook
“Excel Not Responding” is the information from the excel is the heartbreaking message for excel users because often time we lose the data that we have already worked in those scenarios. This usually happens due to heavy data updates or unexpected power loss or computer crashed or even you might close the workbook accidentally without saving the information, this is one heck of a situation, in fact, most of the time I made a crying face because I have lost such an important data because of excel crashing. In this article, we will show you how to recover unsaved excel files.
Follow the entire article to learn about all the techniques.
Enable AutoSave and AutoRecover Tools
When you create a new workbook from another already opened workbook we simply keep working with that new workbook without saving it. At some point of time if the excel or system crashes we still are able to recover that unsaved new excel file.
This method works with the help of excel’s built-in tool i.e. AutoSave and AutoRecover tools. By default, this tool is enabled to use, just in case if this tool is not enabled then follow below steps to enable it.
Step 1: Go to File.
Step 2: Go to Options
Step 3: Now go to Save option.
Step 4: Now on to the right-hand side you can see “Auto Recovery” options.
We can see so many options here, I will explain each one of them now.
- Save the file in this format: From this drop-down list, we need to choose the file extension that we want to save.
- Save Auto recover information every: In this option, we can mention the time interval that needs to be auto recovered every 1 minute, 2 minute and so on.
- Keep the last Auto Recover: Check this box to create a backup file just in case if you have closed the file without saving it.
- Auto Recover File Location: In this, we need to mention the folder path where auto recover files need to be saved.
Once these options are enabled then we can easily recover unsaved excel files.
How to Recover Unsaved Excel Files?
Follow the below steps to recover unsaved excel files.
Step 1: From the active workbook click on the File tab.
Step 2: Under “Manage Workbook” click on the drop-down list to see the option of “Recover Unsaved Workbooks”.
Step 3: Click on “Recover Unsaved Workbooks” to see the list of unsaved workbooks.
Step 4: Choose the latest file which needs to recover, you can find the file based on the date and time. Select the file and click on “Open”.
Now, as soon as you open the file you will see the option stating “RECOVERED UNSAVED FILE”. From here choose the option of “Save As” to save the file in your own desired folder.
Like this, we can recover never saved workbooks if we close the workbook accidentally.
Recover Previous Versions of Excel Workbook
Imagine a situation where you have started the work in the already saved workbook at 04:00 PM in the afternoon, you have worked for 20 minutes and suddenly you have realized at some point in time you made some mistakes let’s say at 04:07 PM. Now you need to go back to the file of 04:07 PM, how do you recover this file?
This is also possible based on our auto-recovery option. If the auto-recovery time is 4 minutes then excel keeps saving versions of excel for every two minutes, so we will be able to recover the file based on these timing.
Step 1: Go to the File tab.
Step 2: Go to INFO.
Step 3: Now you will see “Manage Versions” option, next to this we can see all the previously autosaved files.
Things to Remember
- Set the auto-recovery time as 2 minutes to get the frequent time interval backups.
- If the data is huge then lesser the time you set the more time it will consume while saving the workbook.
- Auto recovery of older versions of excel workbooks will work only for already saved excel workbooks.
This has been a guide to Recover Unsaved Excel Files. Here we discuss how to Enable AutoRecover options and recover Unsaved Excel files and Workbooks, etc along with practical examples. You may learn more about excel from the following articles –