I’ve worked at private companies where this is the case too lol.
This is true even when better software would work instead of the one-size-fits-all-but-isn’t-suitable Excel.
Often to get it to work the way I want is through VBA scripting. And at that point I should be using other software but companies are cheap and don’t want to invest in better tech.