Excel 2007 undo hazard

[Hector]

Hi all,

I recently started using Excel... Excel 2007 actually... and one thing
I've noticed is that when you have several spreadsheets open in one
Excel 2007 instance and repeatedly invoke undo... expecting that it
will only undo the changes to the active spreadsheet so to speak...
you can inadvertently undo changes to the other spreadsheets that
are open in the background.

Does anyone know how to disable that particular "feature" and/or
force Excel to use a separate instance for each spreadsheet?

 

[Jim Rech]

expecting that it will only undo the changes to the active spreadsheet

Not new. Beware your expectations.


An 2007 change undo change is that a file, save does not empty the undo
stack. This is a deliberate feature that was much requested although, like
all new features, someone here complained about it. I forget why.

--
Jim
| Hi all,
|
| I recently started using Excel... Excel 2007 actually... and one thing
| I've noticed is that when you have several spreadsheets open in one
| Excel 2007 instance and repeatedly invoke undo... expecting that it
| will only undo the changes to the active spreadsheet so to speak...
| you can inadvertently undo changes to the other spreadsheets that
| are open in the background.
|
| Does anyone know how to disable that particular "feature" and/or
| force Excel to use a separate instance for each spreadsheet?
|