can't get rid of a Document Recovery file in Excel XP

V

Val

The Excel XP is trying to recover a file but when I try to
open it it says it doesn't exist or is encrypted and it
won't let me delete it. How can I stop this behavior. It
is annoying because every user gets the message and it
isn't even their file.
 
D

Dave Peterson

I've never had this trouble, but maybe this'll work.

Tools|options|Save Tab
gives the location where excel 2002 stores its autorecovery files.
(for me, it's: C:\WINDOWS\Application Data\Microsoft\Excel\)

You may want to look if there's any *.xar (excel AutoRecovery????) files in
there.

I have my autorecovery set for 10 minutes. Right now I have one file there
called: ~ar51C9.xar.

(This file is hidden. You may need to change your view in explorer to show
hidden files.)

After I alt-ctrl-delete and killed excel, I reopened excel and was prompted to
see if I wanted to recover that file. I answered later.

When I looked back, that ~ar51C9.xar file was renamed to: "book2 (version
1).xls".

If I deleted that in windows explorer, the _second_ time (not the first), the
prompt was gone. (The first time, it looked like excel still saw it somewhere.
I just closed and reopened.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top