What is the most frustrating thing about excel?

DataBlake

Well-known Member
Joined
Jan 26, 2015
Messages
751
Office Version
2016
Platform
Windows
For me it has to be it's inability to stop itself from crashing (at least 2016 version). Sometimes when i run a code that infinitely loops by accident i can kiss my progress goodbye because no amount of pause/break will save me 😭
Among other things the fragility of my current "program" workbook is like trying to install a stereo system into a live bomb.
What about you? what grinds your gears?
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,066
Office Version
365
Platform
Windows
Probably the famed "floating-point arithmetic error": Floating-point arithmetic may give inaccurate result in Excel - Office

Sometimes when i run a code that infinitely loops by accident
I don't think I have done that one in years, but I don't really write too many loops anymore without ends.
If you might this happening more than once in a blue moon, you may want to re-consider how you are writing loops. There are many different ways of writing them, many of them which avoid this issue, and many times loops are not even necessary at all.
 

DataBlake

Well-known Member
Joined
Jan 26, 2015
Messages
751
Office Version
2016
Platform
Windows
may want to re-consider how you are writing loops
if im being honest its usually when i'm real sleepy. I work with a bunch of products and have to use arrays of the sheets and a complex system of dictionaries. sometimes i forget to check a variable like UsedRange.Rows.Count for "ghost rows" and it ends up in a huge unintended loop that i cant let run for the entire day.

Lately i get crashes from running a lot of worksheet altering codes in my tests and then saving over my file instead of exiting without saving with a notepad of the changed modules.

tl;dr my IT department deems me too powerful for SQL and MS Visual Studio so i use VBA to create """Databases""" using dictionaries that load up on opening my project. So my workbooks are kind of explosive, but i back them up daily. (i understand excel was not made for these uses and abuses but it still seems fragile to me)
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,795
Office Version
365
Platform
Windows
For me, two things:

I don't like the way I have to scroll sheets using the two arrows, rather than a scrollbar. I like the right-click option however that provides a sheet navigation dialog, but I miss the old way of scrolling.

I don't like the behaviour of CONTROL+TAB. If I have three or more books open then it seems to toggle only between two books. It didn't behave this way in pre 2016 versions, if I recall correctly. Maybe I just need to flip a switch somewhere to change the behaviour?

I will also echo what Joe mentioned. I recently had to describe the difference between two balances - one being derived in Excel and the other in TM1. The difference was purely resultant of precision! It's also not fun trying to explain how the precision difference has come about!

On the plus side - I recall similar topics over the many years that I have been frequenting forums. Suffice to say that many things that we used to gripe about are no longer issues, such as repeating key values in Pivot Tables and a range of formulas. In particular, I find TEXTJOIN tremendously helpful. Excel continues to grow in leaps and bounds!
 

DataBlake

Well-known Member
Joined
Jan 26, 2015
Messages
751
Office Version
2016
Platform
Windows

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,188
Office Version
2007
Platform
Windows
Sometimes when i run a code that infinitely loops by accident i can kiss my progress goodbye because no amount of pause/break will save me
You can use doevents in your tests, if you enter a loop, you could stop it. After the tests you could remove the line.
Check this:

 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,943
For me, two things:

I don't like the way I have to scroll sheets using the two arrows, rather than a scrollbar. I like the right-click option however that provides a sheet navigation dialog, but I miss the old way of scrolling.

I don't like the behaviour of CONTROL+TAB. If I have three or more books open then it seems to toggle only between two books. It didn't behave this way in pre 2016 versions, if I recall correctly. Maybe I just need to flip a switch somewhere to change the behaviour?

I will also echo what Joe mentioned. I recently had to describe the difference between two balances - one being derived in Excel and the other in TM1. The difference was purely resultant of precision! It's also not fun trying to explain how the precision difference has come about!

On the plus side - I recall similar topics over the many years that I have been frequenting forums. Suffice to say that many things that we used to gripe about are no longer issues, such as repeating key values in Pivot Tables and a range of formulas. In particular, I find TEXTJOIN tremendously helpful. Excel continues to grow in leaps and bounds!
Agree on all fronts. I'm glad they finally added TEXTJOIN so we don't have to use MCONCAT from Laurent's morefunc.dll add-in! I just wish they would have switched the 2nd and 3rd arguments and make the 3rd default to something if omitted. Maybe it's just me, but I forget about the 2nd argument every time.

My biggest gripe for this list though is the common crusade Bill Jelen unsuccessfully led a few years ago to try to make Pivot Tables default to Tabular Form. The number of pivot tables I've ever wanted to be in something other than tabular form? Still zero.
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,795
Office Version
365
Platform
Windows
I just wish they would have switched the 2nd and 3rd arguments and make the 3rd default to something if omitted. Maybe it's just me, but I forget about the 2nd argument every time.
Regarding argument order, I suspect it's because the join range argument is a paramarray. Still, I share your frustration. :ROFLMAO:

Now, I'm looking forward to TEXTSPLIT {hint hint}
 

DataBlake

Well-known Member
Joined
Jan 26, 2015
Messages
751
Office Version
2016
Platform
Windows
i crashed excel.......again
but this time i was working on someone's help request so i didnt lose anything.

i rarely use formulas these days, but the advancements with them seem pretty nice.
 

Forum statistics

Threads
1,089,220
Messages
5,406,927
Members
403,113
Latest member
ms_excel_recal_or_die

This Week's Hot Topics

Top