Make Undo stacks track per workbook instead of globally

Last edited by The Microsoft Feedback Team 2 years ago

"Undo" currently works across all workbooks that are open at a given time, so pressing undo on one workbook might undo a change in a different workbook. As someone who frequently has multiple workbooks open at a time, it would be much more helpful to be able to step through the edits made on each individual workbook.

Not right now

Official Microsoft response

Steve K.

Official Microsoft response

2 years ago

Thanks to everyone for the votes and discussion about having undo independently in each workbook. Though this request has been here for a long time, we are listening and we realize that it can be frustrating if you press Undo while you're in one workbook and it undoes something in another workbook. We've been considering the technical challenges to make Undo work "per workbook", and want to share some details about it with you. The undo process relies on the state of all open workbooks being exactly the same after an "undo" as they were before the undone action was taken. One example of how undo "per workbook" is problematic is with linked workbooks. Let's say you have WorkbookA, with a formula that refers to a range of cells in WorkbookB. You make a change to the formula, so there's an action that could be undone. Then you insert a row in workbook B which causes the references in workbook A to adjust accordingly. If you then did Undo only in workbook A, your formula change would be undone, setting it back to what it was before you inserted the row into the other workbook, since the formula change happened before you inserted the row. The range reference in the formula would now be incorrect, since it would not have the reference adjustment that was automatically done when you inserted the row. There are other challenges and tradeoffs that need to be consider between the current behavior and the requested behavior. We wanted to let you know it would be significant undertaking to make this change. Your votes and suggestions help us plan and prioritize, and we sincerely appreciate all the interest. We'll let you know if we have more to share on this one.

0 comments

You must to comment