» TIP #6

Enabling Auto-Save in Microsoft Excel

By default Microsoft Excel does not include a facility for automatically saving documents in the same way that Word does. This can result in lost data should a computer crash after a few hours work and the user has forgotten to manually save the workbook. Luckily the auto backup facility can be added in as an option, to do this go to the tools menu and choose add-ins, from the pop-up window check the Auto Add-in option and click on OK, you may get a dialogue box asking if you would like to install this feature, if so you will need to have your original Office CD or network path available.

Once installed Excel will autosave every 10 minutes thus reducing the risk of lost data should there be an application or system error.