View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default automatic backup? 2007 version

Hi Joe,

In the Excel help file- it has a description of how to "Automatically save a
backup copy of a workbook" but instead of describing how to do that- it
describes the AutoRecover feature. But, that's not what I want- I want to
see the actual backup file get created each time I resave an Excel file-
just like those Word .wbk files.


For Excel, this is a workbook setting.

Open your file, select File, Save-as. On the save dialog, locate the Tools
button and select General options. On the subsequent dialog, check the box
"Always create backup"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com