Change Number of Times Undo Works
Not having the ability to Undo more than 16 times in Excel can be a huge pain sometimes.
The Good News
There is a way to change this to 100!
The Bad News
It involves editing the Windows Registry.
This Microsoft KB Article will give you the details. The trick only takes a couple of minutes to implement and worked perfectly for me. However, I’ve reprinted the Warning message for those who haven’t edited the registry before:
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
I don’t need umpteen levels of Undo. What I need is an undo that will work after a Save, or after one of the other events that clear the undo stack. I’ll keep dreaming. Usually I’ve saved anyway within 100 undo items.
An undo that works after save would be great for any app!