I Can’t Believe You Can’t “Undo” This Thing in Microsoft Excel
Lean focuses on making it easy for people to do the right thing. We also work hard to “error proof” processes and our work to make it difficult, if not impossible to do the wrong thing.
The Throwback Thursday portion of this post looks back at a time when American Airlines took my suggestion and made it harder to do the wrong thing:
And here's a good example of error proofing online:
The other day, I was writing a blog post (to be published in the future) that involved many charts and graphs. So, I was using Microsoft Excel (my spreadsheet tool of choice unless I'm collaborating with others, then I use Google Sheets).
My intent was to copy an existing tab to create a new one.
My finger slipped on the trackpad, I guess, and I accidentally DELETED the tab.
I hit Command-Z, the keyboard shortcut on my Mac. Nothing happened.
I hit Undo in the menu bar. Nothing.
You can't undo this??
I searched online and there's apparently no way to Undo that. See this post for an example. The best you can hope to do is recover it from a saved version of the spreadsheet, but that wasn't an option for me. The tab I deleted was relatively new, so it wasn't in a saved version.
“Autosave” was not enabled, for some reason. That would have helped. Excel wouldn't let me toggle on Autosave as a corrective action for future circumstances. I don't know the root cause of why Autosave wasn't on.
This seems like a bug… the software says AutoSave should be on by default, but it is not.
This seems to be a “known issue.” Ugh. I'll have to dig into that later.
WORKAROUND: Hit “Command-S” more often to save more often. I'd predict this countermeasure won't always happen.
It seems like particular cruel design and a bad User Interface to put “Insert Sheet” and Delete right next to each other, especially when there's no confirmation step required to Delete.
There's no “Are you sure?” dialog box (but I'm sure I've complained about those before).
Or so I thought… I”ve been playing around with this a lot (after saving) I swear that there are times when there's no dialog box and times when there is one. This could be cognitive error on my part.
That could be a situation where somebody accidentally hits “Cancel” — we've all misclicked for one reason or another. I still don't understand why this can't be undone.
PREDICTION: I'll make this mistake again sometime.
WORKAROUND: Use Shift-F11 to insert a new sheet, to avoid accidentally hitting Delete. There's no keyboard shortcut for “Move or Copy,” which is something I do a lot.
Fixing the software would be more effective than me hanging a poster about being careful or slowing down when I work.
When I tweeted about this, I got some other examples from people, including this one:
In VS Code, you edit a filename by right clicking -> rename -> type the new name. If you hit backspace while not in the rename mode, it deletes your file with no undo.— Jacob Paris (@jacobmparis) April 30, 2019
The only way to get it back is to go to the trash and copy it back over, and if you're lucky it's only one file
Are there software applications that you work with that lack basic error proofing? I'm expecting to get stories about Electronic Medical Record / Electronic Health Record systems.
Update: I was working in the Hipcast.com podcast platform, as I finalize moving my podcasts after their huge technical problems (as I blogged about).
One thing we had years ago was a KaiNexus “video podcast.” Yeah, I can barely remember that “video podcasts” were a thing. That's now all done through YouTube and our KaiNexus instructional videos on Kaizen have also been there for years.
So, the KaiNexus team agreed I could just end the video podcast series, which meant deleting it from Hipcast.
This required one click to the left of the podcast…
And a click up top on “Delete” which brought up a dialog box:
Like the American Airlines case, the confirmation doesn't say WHICH selected item. So, I scrolled back down to double check. It would be a bad mistake on my part to delete the wrong podcast (even after things have been moved to the new podcast hosts… I have reasons to not immediately cancel my Hipcast.com account.
Again, compare that to how my website host, WP Engine, handles deletions.
Again, this could be error proofed with a little bit of effort, as American Airlines thankfully did.