How To Recover Lost Excel Files In Windows 8

Let me tell you the shortest horror story ever.

Excel Crashed!

Imagine working on that urgent report or that extremely important dashboard where you accept done such a fantastic chore. You are proud of yourself and all the difficult work you lot have put into it.

But you forgot a central step.

Yous didn't save the Excel file (gasp!!!)

Ok, allow me cut down on the dramatics and come straight to the bespeak.

Excel has a trend to crash, particularly when yous need information technology not to. Somehow, it happens at the worst possible time (not that at that place is a skillful time for this ever).

In such a scenario, your but option is to attempt and recover unsaved Excel files.

In some cases, you lot will be smiled upon past the Excel Gods and you lot'll get the file, and in some cases, you may not.

In this article, I will share all there is to know when it comes to recovering unsaved Excel files. I volition also show you the precautions and pre-emptive steps you need to have.

And if you want to absolutely brand certain nothing goes wrong, I will likewise share a VBA code that will save a copy of your Excel file with a timestamp whenever you save the existing file.

Permit's become started!

• Recover Unsaved Excel Files / Data
  • Recover a New Unsaved Excel File (that has never been saved)
  • Recover Updated Excel Files (the previous version was saved)
  • Recover Overwritten Excel Files / Previously Saved Version (from within Excel)
  • Recover Overwritten Excel Files / Previously Saved Version (from the cloud – OneDrive/DropBox)
    • Getting the Previous Version of the Excel File from OneDrive
    • Getting the Previous Version of the Excel File from DropBox
• Precautions to Enable Piece of cake Recovery of Unsaved Files
  • Enable AutoSave and AutoRecover
  • Automatically Create a Backup Copy of the Saved Excel File
• Automatically Save a Time-Stamped Copy of the Excel Workbook
• Repairing Corrupt Excel Files

All Possible Ways to Recover Unsaved Excel Files / Information

Excel (and even Windows) is highly unpredictable. It can crash anytime and can your Excel files with it.

It'due south a bad situation to be in…

…but there are ways to tackle this.

Excel has a few functionalities where it can help yous recover unsaved Excel files or data in some cases.

Hither are three scenarios where Excel's in-congenital checks tin assist you recover files/data:

1. Y'all are working on a new file (which you haven't saved nevertheless) and your system/Excel crashes.
2. You updated a file which has been saved earlier and Excel crashes before you could save it.
3. You made a fault and saved the changes, but now desire to go back to the previous version.

Let'due south see how to tackle each of these.

Recover a New Unsaved Excel File (that has never been saved)

If y'all are working on something and Excel crashes (or your organization crashes), yous can still recover that unsaved file.

Notation: This method works every bit Excel has an inbuilt AutoSave and AutoRecover functionality. Information technology's enabled by default and so you should be able to utilise these methods to recover the files. In case information technology'due south not enabled, you will accept to practise it to be able to utilize these functionalities. How to enable AutoSave and AutoRecover is covered subsequently in this article.

Beneath are the steps to recover an unsaved Excel file:

1. Open a new Excel workbook.
2. Click the 'File' tab
3. Click on 'Open'
4. Click the Recent Workbook pick (it's at the height-left)
5. Click the 'Recover Unsaved Workbooks' push which is at the bottom
6. In the dialog box that opens, scroll through the list of unsaved Workbooks and open the 1 you desire.
7. Salve the file (using the 'Save As' pick) with a different name in the location of your option.

Past default, Excel saves a copy of all the unsaved files at the post-obit location:

C:\Users\[YourSystemName]\AppData\Local\Microsoft\Role\UnsavedFiles

In the above address, you need to replace [YourSystemName] with the name of your organization (which is 'Sumit' in my case).

You tin besides go straight to this folder (where unsaved copies of Excel files are saved) by opening whatever browser and copy-pasting the address in information technology (in the place of URL).

When yous open any file from this folder, you volition see a notification bar that will prompt you to relieve it.

Click on it and relieve it at a new location with a name of your selection.

Note: Past default, all the recovered unsaved files are in the 'XLSB' format. When you save it, make sure you lot're saving information technology in a format y'all want.

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 y'all have saved earlier, and Excel crashed (or the arrangement crashed or the power went off) when you were working on it.

So you all the same have the previously saved file, just you lot lost the changes y'all did.

Below are the steps to recover the updated Excel file:

1. Open any of the existing Excel Workbook.
2. As shortly every bit 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.
3. When you get the data you want, relieve the file with a dissimilar proper name.

Alternatively, you tin also open up the Excel awarding, and you will meet the 'Show Recovered Files' choice (every bit shown below).

You tin click on it and it will open the same Document Recovery pane.

Recover Overwritten Excel Files / Previously Saved Version (from within Excel)

While in the above two methods you can blame Excel or Windows for crashing or the power failure, this one is purely on y'all.

This is the case when you have a saved Excel file and you update the data and save it again.

But you end up making some changes you don't want now (happens to me a lot).

What you really want is to get the previous version back.

While you tin can't go dorsum in life and correct your mistakes (unless you have a time machine of class), you can do that in the wonderful world of Excel spreadsheets.

In Excel 2010 and versions subsequently that, Excel got an in-congenital feature to help yous get the previous versions.

Below are the steps to revert to a previous version of Excel (even when you accept updated and saved information technology):

1. Click the File tab.
2. In the Info page, click on Manage Workbook, you'll find all the previous versions of that file.
3. Click on the version yous want to restore
4. Save the file (preferably with a new proper name).

When you select a previously saved version and open it, Excel will evidence you lot a prompt as shown below. You can click on Restore to get the previous version that y'all take selected or can save information technology equally a new file with a dissimilar name.

Note that for this to work, y'all demand to make sure that AutoRecover option is enabled. While it unremarkably is enabled by default, it's something yous can check and ensure. I cover how to enable 'AutoRecover' later in this tutorial.

When it comes to recovering unsaved Excel files or information, these are the three in-congenital options in Excel that tin can exist used.

Another manner (which I highly recommend) is to save your files on the deject (OneDrive or DropBox). This takes away a lot of worries as the cloud services proceed previous versions of your files.

Recover Overwritten Excel Files / Previously Saved Version (from the cloud – OneDrive/DropBox)

If you're in the habit of saving your Excel files on the deject – by using services such as OneDrive or DropBox, you lot don't take to completely rely on Excel to help y'all recover unsaved files or lost data.

These cloud services besides keep previous versions of your Excel files.

Let me testify 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.

Getting the Previous Version of the Excel File from OneDrive

To go the previous version of an Excel file, right click on the electric current version in Onedrive and click on Version History.

This volition open the file and you lot tin 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 requite you the option to download that file or restore information technology.

Getting the Previous Version of the Excel File from DropBox

Just like OneDrive, DropBox as well keeps the past versions of the Excel files that you tin revisit and download.

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 desire to see the previous versions.

Click on Version History option.

This will show you all the versions of that file. You tin can open and download this version from DropBox.

In case you accept installed the DropBox folder on your system and continue your files at that place, 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 y'all can see and download all the versions of the file.

Precautions to Enable Like shooting fish in a barrel Recovery of Unsaved Files

While Excel has some default settings that make sure you have good chances of recovering Excel files, it'due south still a expert practice to make sure everything is enabled.

Enable AutoSave and AutoRecover

To make sure Excel automatically relieve your files and show recovery options, you lot need to have these enabled.

Although it should be enabled by default, in case it'southward non, you tin do that manually.

Beneath are the steps to enable AutoSave and AutoRecover functionality in Excel:

1. Click the 'File' tab
2. Click on 'Options'
3. In the Excel Options dialog box, click on Save (it'south in the left pane of the dialog box).
4. Make sure the following settings are enabled (as shown below).

Allow me speedily explicate what these options mean:

• Save AutoRecover information every X minutes: This pick will make sure that your files are saved every v minutes (or whatever time value y'all specify here). This is x minutes past default and I accept changed this to 5 minutes. You tin can reduce this further if yous want.
• Keep the last AutoRecovered version if I close without saving: This will ensure that in case your Excel/organization crashes or you shut a file without saving, a version is saved that tin can be auto-recovered.
• AutoRecover file location: This is the default location where auto-recovered files are saved. You tin can change this if y'all desire.

Annotation: If you have a huge file with lots of formulas and charts, saving it every 5 minutes will atomic number 82 to recalculation and some possible organisation freeze. If y'all don't want that, you can choose a longer time duration (or can alter calculation mode to transmission).

Automatically Create a Backup Copy of the Saved Excel File

While Autosave and Autorecover options are useful when y'all 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.xlsx and I salve it in a folder, this would automatically create a copy with the proper noun – 'Backup of Examination.xlk'

Now, whenever I save the Test file, all the changes are besides saved in the backup copy.

This tin can be useful if you make some changes in a saved file and want to undo information technology. In that case, you can use the backup copy instead.

Or if your file crashes or gets decadent, y'all will have the fill-in copy which volition have the last saved content.

Below are the steps to enable the motorcar-backup feature for a workbook:

1. Click the File tab.
2. Click on 'Salvage Every bit'
3. Click on Browse to open the 'Save As' dialog box.
4. In the Save Every bit dialog box, click on the Tools option (it's in the lower right office of the dialog box).
5. Click on 'General Options'.
6. In the 'Full general Options' dialog box, check the 'Always Create Fill-in' choice.
7. Click OK.
8. Save the file in the desired folder/location.

Now, whenever you lot save this file, an exact copy will be saved with the pre-set up 'Fill-in of'.

Here are a few important things you need to know about using this car-backup functionality in Excel:

• This is a workbook level setting. This means that if you enable it for one workbook, it will but work for that workbook. If you want information technology to piece of work for others as well, you volition have to manually enable it.
• This is dissimilar than Autorecover and Autosave options. These are contained settings and configuring one doesn't bear upon the other. And then you can have a workbook where AutoRecover, AutoSave, and AutoBackup all piece of work.
• The fill-in file is saved with a .XLK extension. This is the extension for dorsum-upwardly files, and yous may see a prompt when you open this file. Just click on Yes and it volition open the backup file.
• The backup file is ever one version behind your main file (except the time you save it for the start time). For example, if you create a new file and enable backup in it and practice some changes and save it. This will salvage the new file also every bit a backup copy of it. At this point, both the files (the main file and the fill-in) will exist exactly the same. Now, if you make some changes in the primary file and relieve it once, it will non be saved in the fill-in file. Merely if you save it again, it will be washed in the backup file equally well.

Auto-fill-in is a skilful characteristic as it gives you the file'southward last saved version in case you make some unwanted changes and salvage the file. You tin can employ the backup file to become the version earlier the last saved version.

Automatically Salve a Time-Stamped Re-create of the Excel Workbook

While all the methods covered then far rely on the Excel in-built features, yous can also use a curt VBA lawmaking to make certain you lot don't lose your work ever.

With a VBA lawmaking, you salve a timestamped re-create of your Excel file as soon as yous save it (or close information technology).

This ensures that y'all always have all the previous versions and you can become back and recover a file in case you lot mess up. Also, since these are time-stamped, you tin can hands find which version yous want (or where you messed up).

Below is the code that will create a timestamped copy of the workbook equally presently as you salve it:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.ScreenUpdating = Faux Dim BackUpPath As String BackUpPath = "C:\Users\sumit\Desktop\Exam\" ThisWorkbook.SaveCopyAs BackUpPath & Format(Now, "dd-mm-yyyy hh:mm:ss") & " " & ActiveWorkbook.Proper name Application.ScreenUpdating = True End Sub

Notation that y'all have to specify the location of the folder where you want to save the backup copies (change the path highlighted in bold in the above lawmaking).

This may hateful that yous end upward with a lot of copies, but information technology tin exist a huge life-saver when you lot're working on critical projects.

You can apply a similar lawmaking to salve a copy before you close the workbook (instead of saving a copy every time y'all save).

Individual Sub Workbook_BeforeClose(Cancel Equally Boolean) Dim BackUpPath As String BackUpPath = "C:\Users\sumit\Desktop\Examination\" ThisWorkbook.SaveCopyAs BackUpPath & Format(Now, "dd-mm-yyyy hh-mm-ss") & " " & ActiveWorkbook.Name End Sub

You lot need to put this code in the ThisWorkbook code window.

To do this, open the VB Editor (keyboard shortcut – ALT + F11) and double click on the This Workbook object in the project explorer.

Repairing Corrupt Excel Files

In case you find yourself with a corrupt Excel file, there are a few things you lot tin do.

Get-go and foremost, y'all can employ the repair option that's in-congenital in Excel.

Below are the steps to recover a corrupt file past repairing information technology:

1. Open the Excel application.
2. Click on 'File' and then click on 'Open' (or use the keyboard shortcut Command + O).
3. Click the Browse button.
4. In the dialog box that opens, select the file that has been corrupted.
5. Click on the small downward pointing triangle in the 'Open' push (as shown below).
6. Click on Open and Repair.
7. Excel will show you a prompt as shown below. Click on Repair.

If y'all're lucky, everything would go smoothen and you'll be able to recover your data from the corrupt file.

In instance repair pick doesn't work, follow the above steps till Step v, and then instead of Repair, click on 'Extract Data'. Excel volition ask yous whether you want to 'Catechumen to values' or 'Recover Formulas'.

You tin try using whatever choice works for yous. Excel will try and extract every bit much data as it can, and create a new workbook with the extracted data.

If this besides doesn't work. you may take to rely on 3rd-political party tools to recover corrupt Excel files.

You May As well Similar the Following Excel Tutorials:

• Reduce Excel File Size
• How to Plow On AutoSave in Excel
• Clean Data in Excel.
• Excel Interview Questions.
• Excel Pivot Tabular array
• Automatically Open up Specific Excel Files on Startup

Source: https://trumpexcel.com/recover-unsaved-excel-files/

Posted by: carringtonthatted.blogspot.com

Share this post