My job involves me working with a lot of Microsoft Excel files. Many companies use it as a defacto database. It also makes a handy data analysis tool in a pinch. And Microsoft pitches it for all of these features.
But then I ran into an issue just yesterday where if you want to lock formulas but have the sheet be sortable, that isn’t something easy to achieve. There is a workaround though! Fear not!
But this workaround now doesn’t let users add new rows to the dataset. The funny part? Microsoft’s own UI gives you options for each of these independent events. You would therefore think that this is all standard. But no. You can’t have the interface do something simple.
The worst part of all this is that I’m sure this is a situation driven by 1990’s programming challenges that were never updated in the newest version. Heaven forbid Microsoft make something that works as advertised….