In article ,
"Dana DeLouis" wrote:

I've always thought that this was an odd ball one because "Excel
specifications and limits" says that the number of Undo levels is 16. One
would normally think of this as being fixed.

Absolutely. I don't think I've ever used 16 undo's so I'd never think
about increasing the number. Besides, I have enough event macros running
in most cases that depending on undo is largely irrelevant.

Just for discussion, I have experimented in the past by setting Undo
history to low values to see if there was any noticeable speed differences.
I didn't like setting it to 0 because it turned Undo off. I did not notice
any real timing differences by setting it to a low value of say 1-3. I did
have it set at 10 for awhile, but with Excel 2003, I'm back to the default
setting of 16.

I guess I wouldn't expect a big difference, especially since it applies
primarily to user actions. Depending on the mechanism used, I'd think it
would have a much bigger impact on memory - perhaps speeding up truly
massive workbooks. I'd expect a bigger difference with Word, for which
undo records macro actions as well.

Thanks for the info, Dana!