I know, I know… Save, save, save as you go. So now what?!!? Here is where Microsoft Office saved the day and several hours of work!
It can crash anytime and can your Excel files with it. Excel has a few functionalities where it can help you recover unsaved Excel files or data in some cases. You updated a file which has been saved earlier and Excel crashes before you could save it. You made a mistake and saved the changes, but now want to go back to the previous version. Recover a New Unsaved Excel File that has never been saved If you are working on something and Excel crashes or your system crashes , you can still recover that unsaved file.
How to enable AutoSave and AutoRecover is covered later in this article. Below are the steps to recover an unsaved Excel file: Open a new Excel workbook. By default, Excel saves a copy of all the unsaved files at the following location: You can also go directly to this folder where unsaved copies of Excel files are saved by opening any browser and copy-pasting the address in it in the place of URL.
When you open any file from this folder, you will see a notification bar that will prompt you to save it. Click on it and save it at a new location with a name of your choice. With this method, you can recover files which you created but never saved. Recover Updated Excel Files the previous version was saved This method can be used for files which you have saved earlier, and Excel crashed or the system crashed or the power went off when you were working on it.
So you still have the previously saved file, but you lost the changes you did. Below are the steps to recover the updated Excel file: Open any of the existing Excel Workbook. As soon as it opens, you will see a document recovery pane that lists all the unsaved files. Click on any the file names to load the data.
When you get the data you want, save the file with a different name. You can click on it and it will open the same Document Recovery pane.
This is the case when you have a saved Excel file and you update the data and save it again. What you really want is to get the previous version back. In Excel and versions after that, Excel got an in-built feature to help you get the previous versions. Below are the steps to revert to a previous version of Excel even when you have updated and saved it: Click the File tab. Click on the version you want to restore Save the file preferably with a new name. When you select a previously saved version and open it, Excel will show you a prompt as shown below.
You can click on Restore to get the previous version that you have selected or can save it as a new file with a different name.
Note that for this to work, you need to make sure that AutoRecover option is enabled. When it comes to recovering unsaved Excel files or data, these are the three in-built options in Excel that can be used.
This takes away a lot of worries as the cloud services keep previous versions of your files. These cloud services also keep previous versions of your Excel files. Let me show you how to get the previous versions from OneDrive and DropBox. I am sure there must be many more such services that have this functionality.
This will open the file and you can see all the previous versions of the file in the pane on the left. Click on the version that you want. It will show you the file content and also give you the option to download that file or restore it. To get the previous versions, go to the file in Dropbox web-portal and click on the three dots for the file for which you want to see the previous versions.
Click on Version History option. This will show you all the versions of that file. You can open and download this version from DropBox. In case you have installed the DropBox folder on your system and keep your files there, you can simply right click on any of the files and click on Version History. Doing this will take you to the web version of DropBox where you can see and download all the versions of the file. Enable AutoSave and AutoRecover To make sure Excel automatically save your files and show recovery options, you need to have these enabled.
Make sure the following settings are enabled as shown below. Let me quickly explain what these options mean: Save AutoRecover information every X minutes: This option will make sure that your files are saved every 5 minutes or whatever time value you specify here. This is 10 minutes by default and I have changed this to 5 minutes.
You can reduce this further if you want. Keep the last AutoRecovered version if I close without saving: AutoRecover file location: This is the default location where auto-recovered files are saved. You can change this if you want. If you have a huge file with lots of formulas and charts, saving it every 5 minutes will lead to recalculation and some possible system freeze.
Automatically Create a Backup Copy of the Saved Excel File While Autosave and Autorecover options are useful when you forget to save the files and system crashes, auto-backup is something which creates a copy of the file whenever you save it.
For example, if I am working on a file with the name Test. This can be useful if you make some changes in a saved file and want to undo it. In that case, you can use the backup copy instead. Or if your file crashes or gets corrupt, you will have the backup copy which will have the last saved content. Below are the steps to enable the auto-backup feature for a workbook: Click OK.
Here are a few important things you need to know about using this auto-backup functionality in Excel: This is a workbook level setting. This means that if you enable it for one workbook, it will only work for that workbook. If you want it to work for others as well, you will have to manually enable it. This is different than Autorecover and Autosave options.
The backup file is saved with a. XLK extension. This is the extension for back-up files, and you may see a prompt when you open this file. Just click on Yes and it will open the backup file. The backup file is always one version behind your main file except the time you save it for the first time.
For example, if you create a new file and enable backup in it and do some changes and save it. This will save the new file as well as a backup copy of it. At this point, both the files the main file and the backup will be exactly the same. Now, if you make some changes in the main file and save it once, it will not be saved in the backup file. But if you save it again, it will be done in the backup file as well. You can use the backup file to get the version before the last saved version.
With a VBA code , you save a timestamped copy of your Excel file as soon as you save it or close it. This ensures that you always have all the previous versions and you can go back and recover a file in case you mess up. Also, since these are time-stamped, you can easily find which version you want or where you messed up. Below is the code that will create a timestamped copy of the workbook as soon as you save it: Name Application.
You can use a similar code to save a copy before you close the workbook instead of saving a copy every time you save. Repairing Corrupt Excel Files In case you find yourself with a corrupt Excel file, there are a few things you can do.
Below are the steps to recover a corrupt file by repairing it: Open the Excel application. Click the Browse button. In the dialog box that opens, select the file that has been corrupted. Click on Open and Repair. Excel will show you a prompt as shown below. Click on Repair. You can try using whatever option works for you.
Excel will try and extract as much data as it can, and create a new workbook with the extracted data.
Microsoft Office Excel, Word, or PowerPoint file you closed before saving pretty far along when you accidentally close the document before saving it (or version if I close without saving enabled inside Microsoft Office. Recover a New Unsaved Excel File (that has never been saved) . crashes or you close a file without saving, a version is saved that can be auto-recovered. Excel crashed, the power went out or you accidentally closed a file without saving . That is frustrating, but don’t be so cut up about it – you can.
How to Recover Unsaved Excel Files [All Options + Precautions]
File that was never saved Saved at least once Versions Options Excel periodically saves a copy of your Excel file. Learn how to recover a file that was never saved and how to recover a file that has been saved at least once. This is a quick way to recover the last autosaved file. File that was never saved If you’ve never saved a file and you accidentally click Don’t Save below when you close Excel or Excel crashes , execute the following steps to recover the last autosaved file. Excel tells you if a recent copy will be available.
If you’ve saved the file
Word Recovery of MS Excel Content from Temp Files Microsoft Office has extensive AutoSave and Auto Recovery options that allow you to rescue your work in the event that it is lost due to a power failure, system crash or plain human error. However many people don’t know how to use these features or that they even exist.
VIDEO: AutoRecover in Excel – Easy Excel Tutorial
If you haven’t saved the information, you can still recover Excel files from the just turned off your computer without saving it, you might be tired and in a panic. If you’ve experienced the mishap of mistakenly closing a file while working on Save auto recover information; Keep the last autosaved version if I close without saving To enable the Save auto recover information options. The file is not saved, and you just lost hours of work. Z minutes’ and Keep the last autosaved version if I close without saving’ are checked.