Bring back AUTOSAVE. Autorecover sucks ass.

[Guest]

With Autosave, if you accidently closed excel (or it crashed) you would only
lose the data entered since last save/autosave. With autorecover, I believe
this is only helpful if Excel crashes. Sometimes I might be working on a
spreadsheet, open another for reference and then close excel (instead of just
the sheet, doh!), forgetting to save changes to first spreadsheet
(temporarily thinking the prompt to save changes is for the second sheet,
which I dont want to save). I know its my own fault for not saving my work
often, and closing without saving changes, but why was Autosave changed to
autorecover? Doesnt Autosave do everything and more than Autorecover? All the
other programs I use have an Autosave, not autorecover, option that I can set
to so many minutes or changes.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...6-870d1b557fad&dg=microsoft.public.excel.misc

 

[Ron de Bruin]

Hi autosaviour

http://www.jkp-ads.com/Download.asp

See
Autosafe.zip (13 January 2003, 228k, Downloaded: 3851 times)

 

[VBA Noob]

http://www.microsoft.com/technet/prodtechnol/office/office2000/tips/exsave.mspx

 

[Guest]

Thanks for your reply, but add-in is not listed, do I need install discs to
make this option available?

 

[Guest]

Thanks for the link. It still irks me though, that we need a work around for
a problem that, in my feeble opinion, we shouldnt have. Will try Autosafe,
looks popular!

 

[Dave Peterson]

Gord Dibben posted this:

Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003.
If you have a previous copy, move it to your Office\Library.
To download the 97 version see here........
http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

 

[Guest]

Thanks Dave, I think this is also what VBA Noob was hinting at. Works fine
now. I am happy again. Still think it shouldnt be an add-in, should just be
there.

 

[Nick Hodge \(MVP\)]

On the other side of that, it caused me nothing but grief when I used it
during XL2000, crashed all the time.

I know it has different functionality but the auto-recover is almost
flawless, doesn't save off files every x minutes, but is that not what
Ctrl+S id for ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk

 

[Guest]

Very true, and I was Ctrl+S every 10 seconds after the first accidental
closing without saving lost about 3 hours work, but then it gets longer and
longer between saves...

I will keep potential crashes in mind, thanks for the warning.

 

[Dave Peterson]

One more reason to not use autosave is that the Edit|Undo/Redo is lost after a
save.

The reason I don't like it is when I open a workbook to do what-if games. I
sometimes make changes that I want to discard. And the autosave makes that much
more difficult.

Very true, and I was Ctrl+S every 10 seconds after the first accidental
closing without saving lost about 3 hours work, but then it gets longer and
longer between saves...

I will keep potential crashes in mind, thanks for the warning.

 

[Guest]

I have left the prompt on, this gives option to "skip save" if you are in a
sheet you dont want to write over (write protect these or open read only?) or
doing something you think you might want to undo. Whether save is done auto
or by regular Ctrl+S you will lose undo etc anyway, only autosave prompt
makes it hard to forget for easily distracted people like me to save often. I
have noticed since using autosave again how quickly 5 or 10 mins goes by! I
will keep increasing mins until I reach a happy medium between being annoyed
by prompt and having too many changes I could lose.