ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel, I want to create a backup copy whenever I save a file. (https://www.excelbanter.com/excel-discussion-misc-queries/92605-excel-i-want-create-backup-copy-whenever-i-save-file.html)

Bearpecs

In Excel, I want to create a backup copy whenever I save a file.
 
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.

Dave Peterson

In Excel, I want to create a backup copy whenever I save a file.
 
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.

Bearpecs wrote:

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.


--

Dave Peterson


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com