View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Steve Zed Steve Zed is offline
external usenet poster
 
Posts: 2
Default Set Excel 2000 to automatically create backup file.

Thanks Gord.
Much appreciated, works fine.

Steve

"Gord Dibben" wrote:

Try FileSave As then at top right of Toolbar hit ToolsGeneral Options(or
Options) and you will get a dialog where you select "always create backup".

I don't use 2000 but it was this way in 97 and is in 2002 and 2003.


Gord Dibben MS Excel MVP

On Tue, 6 Mar 2007 16:59:08 -0800, Steve Zed
wrote:

When I make changes and save them via Ctrl+S or File Save, I would like the
previous copy to become a backup copy. Have forgotten how to do this.