D3 Technology Group - Technical Library

Library

Switching On Automatic Backup and AutoSave

By default Excel does not keep backups or AutoSave copies, but these features can be switched on.
______________
Making Backups

Excel can keep a backup of the current document.
1. click on 'File' then 'Save As' option - see 'Save As' dialog.
2. click on the 'Options' button.
(Excel 2000) click on 'Tools' menu then the 'General Options' option.
3. click on the 'Always Create Backup' option.
4. click OK then click on the 'Save' button.
5. click on the 'Yes' button to confirm the save.

Note - this has to be done separately for each document.
________

AutoSave

The 'AutoSave' feature protects you from power failures and other sudden switch off situations. To switch the AutoSave feature on do the following:

1. click on the 'Tools' menu then the 'Add-Ins' option.
2. ensure that the 'AutoSave' Add-In is checked.
3. click OK.

Excel will now attempt to recover your document when you next run Excel after a power failure.

Source
David Bleasdale
domino.lancs.ac.uk/pub/usghelpdesk.nsf/0/3B01D23A1FFB72858025685F00367242?OpenDocument

Submit An Article