I am seeing the last option you spoke of: xlk. Essentially, we want to have
a back up made so that if anyone wrecks the original, there is a back up we
can use. Some how or way someone is accessing that back up? or so I have
been told and using the back up as the original doc. Our hope is to find a
way to create an auto back up but passoword protect it or send it to a secure
location. Thanks for the help! Roxanne

"Dave Peterson" wrote:

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