Gord,
my answers are below.
yarp.

"Gord Dibben" wrote:

yarp

1. Auto-save is not involuntary. It is an add-in that can be unchecked in
ToolsAdd-ins in versions 2000 and earlier.

It is involuntary beause you never expect it, and you're not asked about it.
Also, it is set to "on" by default (and so it should be). Many users don't
even know they can change it, not to mention that they don't know how.


The Autorecovery feature of Excel 2002 and 2003 does not delete the undo
stack.

It sure does. I just re-checked it. Maybe you should try working on a fresh
installation or something like that.
This is really a serious problem. You make changes to a document, and
suddenly, when everything's going OK, something happens really quick and then
you find your Undo button disabled. It took me some time before I realized it
was the Auto-save.


2. Read this KB article to learn how to increase the number of undos.

http://support.microsoft.com/default...US;q211922#top

I just did. I followed it and it helped. Thank you (and Dave Peterson above).
However, I think that the common user would like to have control over the
number of Undo actions in history through the Tools-Options dialog box.
My father, for example doesn't even know what the registry is. He needs
Excel to be reliable. So if the number of Undo actions in history is not
"endless", then it must be allowed to be changed through the application.


3. Maybe a good idea, but a potential resource hog IMO.

OK, so the default of this option should be "off". Moreover, in MS-Word's
"Save As" dialog box, the "Save" button has a drop-list of options. This can
be a nice way of enabling this option while still keeping it quite hidden, so
that not everyone who saves a document will save all the Undo history along
with it.



Gord Dibben Excel MVP

On Mon, 8 Aug 2005 08:41:38 -0700, "yarp"
wrote:

1. In my opinion, it's very problematic that the actions in the Undo button
disappear each time an Auto-save is performed. Auto-save is involuntary, as
opposed to a Save action the user performs. I also must add that I didn't
notice this phenomenon happen in other Office applications.
2. Also, there should be a way of setting the number of Undo actions Excel
should keep, with an option of saving an "endless" number of actions. If my
computer can't handle it, I wouldn't mind if at some point a task pane will
appear, informing me that the system free resources are getting low and
allowing me to delete some of the Undo actions that were saved.
3. Furthermore, suppose that I'm in the middle of working on an Office file
while suddenly I have to go. Wouldn't it be nice if I could save an Office
file together with its Undo actions?

----------------
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