In Excel, I want to create a backup copy whenever I save a file.

B

Bearpecs

In Word, I can set Tools/Options/Save/Always Save Backup Copy. Why doesn't
Excel let me do that?
I do NOT want to turn on Autorecovery.
Thanks.
 
D

Dave Peterson

They're two different programs.

In excel, it's a workbook by workbook setting.

File|SaveAs|Tools|General options
check always create a backup.

You have to do this for each file.
 
Top