Backup Option in Microsoft® Excel® 2003
Are you curious to know about backup option in Microsoft Excel 2003 and its usage?
Microsoft Excel 2003 automatically saves a backup copy each time you save a workbook. This backup copy provides you with a previous saved copy, so you have the current saved information in the original workbook and the information saved prior to that in the backup copy. Saving a backup copy can really protect your work if you accidentally save changes that you do not want to keep or remove the original file. One of the best ways to prevent the data loss is to backup data regularly. The 'Automatic Create Backup' option can be accessed from the 'Save As' dialog box by clicking 'General Options' on the 'Tools' menu. It is not selected by default. If you select this option in a file, it will set only for that file. To change this for all documents, modify the templates for the default start up worksheet or workbook.
The following are the some of the details of backup option in Microsoft Excel 2003:
- Auto Recovery
- Always Create Backup option
- Enable auto backup
First, you have to click on the 'Tools' menu and then select 'Option'. Click on the 'Save’ tabs and select the 'Save Auto Recovery info every' check box. In the 'Minutes' box, type or select a number to specify the interval for how often you want to save the files. The more frequently your files are saved, the more information is recovered if there is a power failure while a file is open.
Always Create Backup option
Microsoft Excel includes an 'Always create Backup' option. This feature always saves your previous versions of Excel workbook when you save changes to your current Excel. This gives good protection against file corruption. The information of the backup files will be saved out of date. That is, the backup file will not include your most recent set of saved changes.
In Microsoft Excel 2003, you have to click 'Save as' and you will get 'Save as' dialog box, which prompts you for a file name. In the top right corner of the dialog box, you will see a 'Tools' button that opens a drop down menu. On the menu, you will get 'General Options', click on it and you will find the ‘Always create backup’ check box here.