View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Set Excel 2000 to automatically create backup file.

Thanks for the feedback.

Now I know 2000 is same as other versions.

On Tue, 6 Mar 2007 19:09:13 -0800, Steve Zed
wrote:

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.