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.

autosaviour wrote:

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.

"Nick Hodge (MVP)" wrote:

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

HIS
www.nickhodge.co.uk
"autosaviour" wrote in message
...
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.

"Dave Peterson" wrote:

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

autosaviour wrote:

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/comm...lic.excel.misc

--

Dave Peterson





--

Dave Peterson