I think it's gone.

For the future...

You may want to turn on Autosave (tools|addins--you may need your original CD)
to install it.

Or....

You may want to consider using Jan Karel Pieterse's addin called AutoSafe (note
spelling).

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)

Jan Karel's version will know if there was a crash and prompt you to open the
last version it saved.



Vivek wrote:

hi im vivek

we were using a xls file which was shared in our lan, but one computer where
it was physicaly present and opened in EXcel 2000, the excel generaetd error
and got closed and from that instance this file is not viisble, i have tried
to search it on n/w and the local comp where it was stored,but im not getting
it. pls tell me if any one had faced thsi prob how to recover it, b'cause its
very imp file for us. i got very confused how a file can be get vanished when
a excel prog got error,

--

Dave Peterson