Excel

179 readers

1 users here now

A community dedicated to any discussion about Excel. QnA, Discussion of other spreadsheet applications and ancillary programming/scripting are also welcome.

founded 1 year ago

MODERATORS

Baffling7900

Functions behind paywall (self.excel)

submitted 1 year ago by BeardyGrumps to c/excel

5 comments fedilink hide all child comments

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.....

you are viewing a single comment's thread
view the rest of the comments

[–] BeardyGrumps 1 points 1 year ago

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...