I auto create a backup for each Word doc. How can I in Excel?

[Dollins13]

I automatically create a backup document in Word. This is very useful when
accidentally saving something I didn't want to change. I would like to do
this in Excel, as I just saved something I didn't want to change. How is this
done in Excel. The Office Assistant wasn't very helpful. Thank you in advance
for any assistance.

 

[T. Valko]

What version of Excel are you using?

Excel 2007:

Office button>Save>Tools>General Options>Always create backup>OK

Other versions:

File>Save>Tools>General Options>Always create backup>OK

 

[Jacob Skaria]

For a specific file from.... File Save Dialog window Tools>General Options>
check 'Always create backup'

If this post helps click Yes

 

[Dollins13]

Thank you. I knew there had to be a way. I just couldn't figure out how. Have
a great week.

 

[Dollins13]

Thank you. I knew there had to be a way. I just couldn't figure out how. Have
a great week.

 

[Dollins13]

Thank you for responding. I tried that several times, but I can't find the
backup in the directory. Will it be there like it is in Word, or will I have
to look somewhere else? Thanks for the help.

 

[Jacob Skaria]

Excel backups have the original name and the suffix .xlk (with a displayed
filetype of 'Microsoft Excel Backup File') and will appear in the same folder
as the original. With the Excel backup you can use Autosave and backup
simultaneously

If this post helps click Yes

 

[T. Valko]

You're welcome. Thanks for the feedback!