Had to vent somewhere; spent a few week on and off developing a compensation system in Excel and PowerBI for a company with several divisions. Pretty simple stuff; they just wanted to benchmark and log compensations across different geographies.
In order to populate some dropdowns I used the functions SORT, UNIQUE and FILTER for the first time. Was told all clients use Excel 2019 whereas I have a office 365 subscription. Well it turns out these functions are not available in excel 2019 home and business; only in the Office 365 version. (Even though I checked the version numbers of excel and we were all using the same).
What kind of money grabbing scheme is this… Was a simple workaround by creating the same functionality with a few lines of VBA but even so…
Wait they really did that… Jesus. I like Microsoft products as a whole but they do make some really shitty decisions. One that got us was their switching of PowerBI pro licences where you went one day from only needing a licence to write a report to needing a licence to view the report as well.
It comes back to bite them though as we are in the process of choosing a new ERP solution and Dynamics is probably off the table as the board keep raising the issue of trust in pricing…