Technology Computer & Networking security

Microsoft Excel"s Disaster Discovery

I still remember, the first lesson in my computer class, trainer started with the following advice: "Always save your data early and often.
Sometimes things fall apart quickly before you even have a chance to react".
It is always a good habit to always save your document as soon as you create it.
However, you will never know when your computer or software is going to behave abnormal, crash or shutdown.
As a Microsoft Excel user, you are lucky enough as it comes with an invaluable safety feature called AutoRecover.
The AutoRecover saves backup copies of your Excel worksheet periodically in the background while you are working with it.
If for any reason, Excel crash or the system hang, you can retrieve the final backup of AutoRecover even if you never managed to manually save the file.
Of course, you cannot expect AutoRecover to save up to the last second of the information you entered to the spreadsheet you were working on.
However, if the if AutoRecover backup in every 10 minutes, which is the default setting, in the worst case scenario, you will lose 10 minutes of work.
Anybody who experienced of losing the entire document without saving the file they were working on, surely will appreciate this handy feature provided by Microsoft Excel.
If your does undergo a system or operating system crash, after you reboot the computer, you can quickly recover your previous spreadsheet file that the AutoRecover last backup.
What happen was every time when a user launches Microsoft Excel application, the software will automatically checks the backup folder.
If there is any backup found in the folder, Excel opens a Document Recovery panel, which will be located on the left of the Excel window.
If the Excel or computer crashes while you are editing the backup file, the next time you open Microsoft Excel, you will notice that there are the same file listed twice in the Document Recovery window.
The difference between these two files is the status.
The status with [Original] indicates it is the last version of the file that you saved.
This is the original version which is safely stored on the hard drive.
While the other version which shows [AutoSaved], indicates the most recent backup created by Excel.
Click on the backup file listed in the Document Recovery window to open it.
Note that there is a drop-down menu on the right of each file listed.
You can click the drop-down menu for additional options.
Again, it is a good practice to save the backup file that you just opened before you start to work on it, because it is just a temporary backup.
If the file that you are trying to open is already corrupted, then Excel will automatically attempts to repair it.
You can also choose Show Repairs to look at a list of changes Excel had to perform to recover the file.

Leave a reply