program blinks and I lose 3-4 hours of work, autosave set 10 minut

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

2 times I have been working in Excel, I have worked for hours and the program
blinks and I loose everything (last time 3 hours) until it was saved the
night before. There was nothing in the recovery folder except what was saved
the night before. The auto save is set at 10 minutes. This has hapened before
in Excel 2000 and I thought upgrade to 2003 would a difference, but it just
happened again.
 
I don't like Excel's autorecovery system. A colleague, Jan Karel Pieterse,
has made available a program called AutoSafe, which works much better. It
saves a copy of all open workbooks in a special directory at a given
interval (like 10 minutes). When it saves another, the older ones are left
in the Recycle Bin, so you can go back a few versions if necessary. The
AutoSafe program (and a few other useful add-ins, such as the Name Manager)
are located at http://jkp-ads.com.

I think neither system will make a save if the VBA debugger is active (i.e.,
you're stepping through the code) when it's time to make a save.

- Jon
 
Back
Top