This might be the funniest MS Office thing I have encountered yet:
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr I find that if I have to work on data that is complex enough to require me to have more than one instance of excel running at the same time there are better tools for handling the task than excel.
-
@aesthr I find that if I have to work on data that is complex enough to require me to have more than one instance of excel running at the same time there are better tools for handling the task than excel.
@pmb00cs the actual example today:
one file containing a list of appointments, one a log of client phone calls. both with maybe a few dozen rows between them. nothing complex, stuff you'll find in most offices probably that aren't run by tech people
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr wait what?
-
@aesthr wait what?
@tante welcome to my regular workday in a MS equipped office
-
@pmb00cs the actual example today:
one file containing a list of appointments, one a log of client phone calls. both with maybe a few dozen rows between them. nothing complex, stuff you'll find in most offices probably that aren't run by tech people
@aesthr yeah, I'm not saying it's an uncommon usage pattern, or that I have all the answers. But you've got to admit that there are better tools than excel for handling data.
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr Given that MS Office products also still cannot open two files with the same name from different locations, I'm probably less surprised than I should be.
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr Oh my, I was immediately thinking that cannot be true. So asked from better half (who uses MS Excel daily) and I didn't even had to finish the question to get answer "Yes and that is so infuriating! At least I have multiple monitors where I can spread the documents so probably notice that.."
-
@aesthr yeah, I'm not saying it's an uncommon usage pattern, or that I have all the answers. But you've got to admit that there are better tools than excel for handling data.
@pmb00cs sure, personally I use R for any data analysis, but that's really irrelevant when I'm in a low level job in an office where IT stuff is handled by an external service company and I can't install anything, and that's just the workplace reality for many people
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr I've seen a lot of stupid shit when working in IT but this blows all that away. It's stupid stupid stupid
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr I remember working in QA for Microsoft on MS project ages ago. We had to take direction from Office on features including the UI. I was testing undo redo in Project and logged bugs about it undoing things in other docs silently. I was told that's the way Office did it, so it was by design.
I tried. I hate that design decision to this day.
-
@Canageek @MatthewPCooke @aesthr All Office programs were MDI, but Excel was always special (the global Undo thing didn't apply to any other program, nor did a bunch of other things that Excel still does weirdly, especially when working with multiple documents).
@jernej__s @Canageek @aesthr to be fair, I have genuinely seen a lot of inter-document linking and data loading amongst finance teams where as word documents are usually separate. That might also go some way to explaining why word went SDI about 15 years before Excel…
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
yeah... with excel, UI/UX really stands for User Interface Universally eXcrement...
-
@aesthr Gods. This explains -so- much.
I thought Excel was broken, somehow.. (well, it is, but that is beside -this- point). Who in their right mind ok'ed this..
@tofticles @aesthr It possibly made more sense back when it was an MDI application. Having GUIs make logical sense stopped being a design requirement around Windows 8 at the latest.
-
@aesthr I use excel daily, and I hate this "Feature".
I only want to modify the excel in the active screen, if it does anything else it's wrong.
This site has some options for work arounds, but the best one the registry edit can't be done on corporate machines.
https://spreadsheetplanet.com/open-multiple-instances-excel/ -
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr Back in my Excel VBA programming days, it took me two weeks to realize that opening another workbook clears the clipboard.
️ -
@aesthr I remember working in QA for Microsoft on MS project ages ago. We had to take direction from Office on features including the UI. I was testing undo redo in Project and logged bugs about it undoing things in other docs silently. I was told that's the way Office did it, so it was by design.
I tried. I hate that design decision to this day.
@Sablebadger @aesthr Seems to be to break the "principle of least surprise." I always thought you needed a *really* good reason to do that.
-
@tante welcome to my regular workday in a MS equipped office
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr i have similar issues with undo in Logic Pro X. If i undo a recording, it also deletes the lyrics. It also sometimes does an undo as 2 things to be undone. Other times, like after a recording, it will not undo the recording, but undoes the thing that happened before the recording. I have had to unlearn my undo hand gestures. This was not a problem a few years ago by the way… but thanks to AI, it is now!
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr I seem to recall this isn't limited to Excel but every Office program combined since they started bundling them together in the 1990s.
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr utterly bonkers
