The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
My real need is for an Outlook replacement for the Mac, email and calendar working off of Microsoft Exchange Online. Using Office 2011 today but it has quirks in the current macOS High Sierra and Mojave.
Some of the files I work with are streams, and I can use a macro in UltraEdit to separate a .csv into X12 fields or database entries. The column mode is nice as I usually end up reformatting SQL from entry level developers in order to be able to read their code.
Got this dilemma at the moment, was intended on buying outright, but the cost of buying is six years 365, and in six years time and I still going to be using it? Probably not so I'm edging toward 365. Worse case it'll all come out in the wash.
Joan, have you looked at what is included in the Office 365 subscription?
If you need a single license for Office and none of the extended features, Office 2019 is probably a better choice. You pay more up front ($250 USD) but can be used for years. Unless Microsoft comes up with some type of immensely useful new feature, there's probably no real need to upgrade again until 2019 goes out of support in 7 years.
However, the 365 Home version includes licenses for 5 people on PC/Mac, phone, and tablet. Plus it includes 1 TB of OneDrive space/person + Skype. If you need multiple licenses, it's the clear winner.
If you buy any extended online storage (DropBox premium, etc) then 365 is also the winner, as the prices for storage are roughly the same cost as 365 ... and it includes MS Office.
I prefer Office 20?? for personal use but have Office 365 because the monthly pricing, a family licensing option and integration with my server, laptop and phone makes life easier. Biggest factor is the price. Can you image the cost for yourself, wife and kids if you were using Office 2019 on all the devices at home not to mention software updates.
I use 365 Home at home. Five users for $100/year means $20/user/year. How many years at $20/year would it take to pay off a 2019 license?
Keep in mind, I've always been anti-subscription because of not wanting my software to expire. I just couldn't make that argument with the 365 Home pricing. The price was too reasonable. The Adobe stuff, on the other hand, is a totally unreasonable subscription.
I actually go looking for an Office/365 "gift card" around Christmastime every year when they go on sale for $80. That brings it down to $16/user/year.
I haven't analyzed the business/enterprise/education offerings. All I know when it comes to those is that Microsoft is having a whole lot of success with them. So presumably other business people have done their math and decided its the way to go.
Apart from the reliable revenue stream, there is another reason for Microsoft to prefer users be on 365. Fewer customer support headaches involving users who have old, but still supported, versions of Office. Every software developers will readily acknowledge they hate getting bogged down supporting old versions of software.