Just #2...

Undo has a limit of 16 actions, but it's resizable by tweaking a registry
setting.

xl2k and above
XL: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=211922

xl97
XL97: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=162944



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

--

Dave Peterson