View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Change location of auto saved back up copy of shared workbook?

Autosave overwrites the original file.

Autorecovery writes to a user selectable folder--but the file is destroyed when
that workbook is closed successfully.

Autosave came with xl2k and below. Autorecovery is included in xl2002+. They
actually serve different purposes.

Any chance that you have some other file that's being accessed.

There is an option to create a backup file when you save the workbook.
File|saveAs|tools|General Options|Always create backup.

This option creates files with extensions of .xlk.

I'm not sure which one of these (if any) you're seeing.

Roxanne M wrote:

We have a shared workbook here and are finding that someone is accessing the
back up rather than the orginial doc and it is creating problems. We have
set the auto save but would like to change the default location or password
protect the back up copy only.

On an aside, we have forgotten how to set the auto save, so a reminder on
that would be great too. Thanks, Roxanne


--

Dave Peterson