AutoRecover in Excel 2002

  • Thread starter Thread starter Lyle York
  • Start date Start date
Hi
you may state your exact problem :-)
If you have problems recovering a file one solution could be getting
OpenOffice and try to open a corrupted file with that application
(worked for me once)
 
Short descriptions:

Autosave (an addin in xl versions before xl2002), the workbook gets saved at
user selectable intervals (just like a manual save). (If you're running
xl2002+, then if you can find a copy of autosave, it'll work with that version,
too.)

xl2002+ has a feature called autorecovery. It's used to catch catestrophic
events (excel/windows crashing). But it won't help if you never save or close
excel normally.

But Jan Karel Pieterse has an addin that's the best of both worlds: 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.

=====
You may want to get a copy of Jan Karel'saddin. It might save a few tears in
the future.

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