this post was submitted on 18 Sep 2025
541 points (98.7% liked)
Technology
75300 readers
6279 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related news or articles.
- Be excellent to each other!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
- Check for duplicates before posting, duplicates may be removed
- Accounts 7 days and younger will have their posts automatically removed.
Approved Bots
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
LibreOffice Calc. I think it still has some performance issues vs Excel with extremely large files, and it can only do 1024 columns. Also LibreOffice Basic can do a lot of what VBA could but the syntax is different and I don’t think it integrates well with the rest of the system like VBA’s COM integration (as unsafe as that was)
If you aren’t pushing Excel to its absolute limits then it’s more than enough.
You could try SoftMaker office for 30 days to see if their version of Excel is better.
Yearly subscription: https://www.softmaker.com/en/products/softmaker-office/download Perpetual license: https://www.softmaker.com/en/products/softmaker-office/download-permanent-version Comparing the different versions: https://www.softmaker.com/en/products/softmaker-office/order-all
Bonus is that the license will work regardless if you use Linux, Mac or Windows. And the 2024 version is GDPR compliant.
What about tables, pivot tables, power query, grouping of rows and columns , and how is formula/function parity (xlookup, index, match, sumproduct, etc)?
I've made some truly Frankenstein sheets that I'm not sure could be stitched together elsewhere.
Why excel for super complex computations? At some point, just code your solution instead... It's easier than troubleshooting Excel
I don't have any issues. It's free to download to any operating system. So give it a try. See if it can open your existing Excel spreadsheets
I am having vague nightmares of the Momte Carlo and Black Scholes sheets we would have to compile for financial engineering classes in college...