Can I create a backup copy?

[Guest]

You can have Word create a backup of your doc each time you save the doc.
Can you do the same in Excel?

 

[Harald Staff]

Yes. It's set in the SaveAs dialog, Tools button, General options. (Exact
location may vary with versions)

HTH. best wishes Harald

 

[Dave Peterson]

Just to add to Harald's reply...

The setting is for the workbook. In MSWord, this setting affects all documents.

You could create a book.xlt workbook template and store it in your XLStart
folder. Change this setting to create a backup.

Then each workbook that is created from that template will inherit this
setting--this won't affect any existing workbooks.

You have to do them via the dialog.