In Excel how do I 'always create a backup copy' like I do in Word.

M

maryannpatty

In Excel is there a way for me to 'always create a backup copy' like I do in
Word?
 
L

LHarris

Mary,

It is simple. The first time you save a file, enter the file name and before
clicking on the save button click on the Tools Menu in the Save Dialog box;
then click General Options. The Save Options Dialog Box comes up. You can
check "Always Crete a Backup."

Lharris
 
N

Neil C

Any idea if this can be made the default position? Unless you consciously
carry out the sequence below (easily omitted), the default position seems to
be NOT to create a backup copy. Seems to me to be a dangerous default.

"Tools, Options, Save" offers no help.

Regards
Neil
 
D

Douglas J Steele

I'd suggest asking this in a newsgroup related to Excel.

This newsgroup's for questions about Access, the database product that's
part of Office Professional.
 
Top