If the undo history is set to zero, no memory is allocated for undoing actions. The higher the undo history value, the more memory Excel allocates for the history. This directly affects the performance of your computer when you run Excel.
Microsoft has written an article about this on their website (Article ID 211922):
When you run a Visual Basic for Applications macro, Excel allocates no memory for undoing actions. This feature is disabled for optimization of performance when you run a macro. (See also 'Not all tools in ASAP Utilities have an undo'
You may also like:
Filed under: General on May 28th, 2007 by Bastien | Comments Off on How to increase the number of undo levels in Excel