Make Undo stacks track per workbook instead of globally
Undo stacks are currently global between 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.
Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!
Yes, this would be a major improvement for Excel to have separate UNDO lists for each open workbook, and to NOT wipe out the UNDO history when you save. Please prioritize this.
This is absolutely a necessity. The number of times I've been working on two sheets, and had to undo in one but not the other is legion. Especially the fact that save WIPES OUT THE UNDO HISTORY - whoever thought that nonsense was a good idea?
Seriously, we need a separate undo per workbook, which isn't wiped out when you save.
Made an account just to vote for this. Such an annoying 'feature'.
Curious as to what user testing lead to this decision in the first place.
Angela Wu commented
YES! Please fix this!! this is the most unfriendly and inconvenient feature EVER.
No other programs have problems like this.
I don't know how much double work I've had to do because of this. Time wasted, and work quality affected whenever redos are missed!
Please separate the undo stacks by workbook!
I often click undo a few times and Bam, another workbook pops to the front, and something I did a while ago on another topic has been undone.
Where did the undo history from my current workbook go? Sometimes it's just gone, and that's when it usually jumps back to another file.
I agree this is a very annoying "feature" and there should at least be an option to turn it between global and per document/workbook
Please fix this bug. Acombined undo/redo for different documents makes no sense whatsoever and essentially breaks this functionality if you work on more than one independent document at the same time in parallel!
Agreed. This is the worst function of the new Excel. And what's worse, if you close the other spreadsheet, all of your undo history is lost to the aether. It's incredibly short-sighted and poorly thought out, like most of Microsoft's newer features.
Nancy Edwards commented
Throwing my hand into the mix....PLEASE fix this!!! I often have 19 budget files open at once and this undo across all of them is horribly frustrating!!!
Derek Schmidt commented
Seumas, I wonder if this has anything to do with the inability to load two files of the same name.
SEUMAS MACLAREN commented
This Undo issue is a bug and the height of lazy design. No two ways about it. It is one of the MOST inconvenient, non-standard, deviant and lazy things that Excel has just left in there, version after version, despite the fact that many users of so called Office Professional editions and above routinely use mutiple spread sheets and cannot seriously be expected to use an undo buffer that undos (to the user) randomly, across different workbooks!
Unless one in not changing more than one workbook, this is a useless function. The workbook one is correcting requires an undo every so often, not the one being referred to, where only zoom levels are being used. (And please please can we NOT store zoom levels as document changes to undo? This is just silly. Other competitor products have full separation and, by the way, so does Word.
PLEASE harmonize the technology better across Office applications: UNDO, SEARCH and allow colours to default to Window default settings when using Classic desktop scheme.
Jonathan Rounding commented
Please Prioritize! This makes my life needlessly frustrating.
Yes. And please, make it also per user. When you collaborate, it is such a mess using the undo. Undoing somebody else changes just does not make sense.
[Deleted User] commented
Please do prioritize!
Kraig DeMatteis commented
1 year and 3 months later, this must be a bear of a fix! Is global Undo a preferred feature to regular users, or have millions of accountants, brokers, financiers and engineers found their own workarounds? I use Excel just enough to be inconvenienced by a global Undo and would vote to separate the functionality into individual instances (thanks for fixing that, btw).
PLEASE PRIORITIZE... this has caused hours of re-work and is not even logical to have it globally!!!! Bosses are NOT happy with this.
Please do prioritize!
Please do prioritize!!!! I just lost an hour's work when I closed a totally unrelated spreadsheet. This is among the most obnoxious features in Excel.