undo button isn't working -- HELP!

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

Undo button doesn't allow for multiple undo actions. In
fact, most of the time, it doesn't seem to be active.
Sometimes, I'm allowed to undo just the last action. HELP!
 
There are actions that reset the undo stack. (saving a file, running almost any
macro).

But if you don't do anything that clears this stack, you should be able to go
back a few actions.

(And that macro that you're running can be a event macro--like a worksheet event
that runs almost without your knowledge. Any chance that's what's happening?)
 
In Excel XP, the AutoRecover feature will also clear the Undo memory. I
believe this does a save in the background and will cause the problem as
Dave has mentioned. You may have it turned on, with a short time between
saves.
Check <Tools> <Options> <"Save Tab">
At your own risk <vbg> you may want to experiment and turn this feature off.
Or, perhaps increase the time between saves.
I believe there was a "similar" feature if you are using a version prior to
XP.
 
Back
Top