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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I stop Excel 2007 from creating backup copies? 2
automatic backup? 2007 version 3
Excel 2007- can't get it to automatically make backups 1
Auto-save backup? 2
Backup Excel file 1
How can I turn on or off for backup file with XLK extention? 1
Saving excel backup copy - path? 1
Excel automatically creates a backup speadsheet 1

Top