Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This has been driving me crazy lately. I'm not used to having having a program have a global undo/redo functionality (as in when I undo something, it will undo the last action in any currently open Excel window). I'm used to having each open window having its own undo/redo list. How can I get Excel 2007 to function more traditionally like that?

share|improve this question
    
what exactly do you mean with "window" ? Separate files? – klyonrad Jun 15 '13 at 11:21
    
Yes, each window having a different file open. – supercheetah Jun 15 '13 at 13:26
    
possible duplicate of Excel: how to undo in current file only? – Ƭᴇcʜιᴇ007 Jan 8 '15 at 16:52
up vote 7 down vote accepted
+300

If you want separate undo/redo lists, open separate instances of Excel.

If you simply open multiple files by double-clicking, they're opened in the same Excel process and share the same undo/redo list. If you manually open multiple instances of Excel and then open your files in those instances, they don't share the undo/redo list.

For further details, you might want to check out:

share|improve this answer
1  
you can also achieve it programatically – user222864 Jun 25 '13 at 13:54
    
As I have explained in superuser.com/questions/862263/…, I don't know why it didn't work for me. – hossayni Jan 13 '15 at 18:05

Unless operating on Excel files in different sessions I think we are stuck with a single undo list.

Edit that may (and quite possibly may not) help to explain the issue:

In Sheet1 A1 enter 1.
In Sheet2 A1 enter =Sheet1!A1.
In Sheet2 B1 enter =A1+1.
In Sheet1 B1 enter =Sheet2!B1

Both sheets now look the same and the undo stack has:

Typing `=Sheet2!B1` in B1  
Typing `=A1+1` in B1  
Typing `=Sheet1!A1` in A1  
Typing `1` in A1

Separating this out into the two sheets:

Sheet1                         Sheet2  

Typing `=Sheet2!B1` in B1
                               Typing `=A1+1` in B1
                               Typing ` Sheet1!A1` in A1
Typing `1` in A1

Unwinding just the Sheet1 part of the history is equivalent to deleting the contents of Sheet1!A1:B1. Try that and the values in Sheet2 will change. So even a separate undo history for each sheet/workbook/window would not achieve ‘isolation’.

Excel may (quite sensibly, in my view) be assuming that there is some basis for having two workbooks/windows open in the same session – that there is reason to expect interaction between one and the other. If such interaction is not required there is always the option to open workbooks in a different session.

At all frequent use of different sessions (eg extended desktop) may soon illustrate some of the advantages of operating within a single session.

share|improve this answer
    
I fear you may be right. – supercheetah Jun 17 '13 at 20:59

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .