1302

submitted 11 months ago by cm0002@lemmy.world to c/programmer_humor@programming.dev

85 comments fedilink hide all child comments

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

[-] isVeryLoud@lemmy.ca 50 points 11 months ago

Excel is a hammer.

When holding a hammer, everything looks like a nail.

Stop using Excel for anything more than simple data extraction and pivot tables, get a custom solution tailored to your needs rather than a monstrous Excel document that consumes 14 GB of RAM to run.

[-] bfg9k@lemmy.world 39 points 11 months ago

We support a financial institution that uses ~30MB Excel sheets with thousands of calculations and they wonder why they can't send it via email or why it has issues when 10 people edit it at once

Just use a goddamn database

[-] ArtVandelay@lemmy.world 15 points 11 months ago

MyExcelDB powers thousands of institutions daily

[-] Randelung@lemmy.world 10 points 11 months ago

The bad thing is, they've attached a mediocre screwdriver to the hammer because everybody keeps using the hammer as a screwdriver. But now, everybody STILL uses the hammer as a screwdriver. The screwdriver part used to be a separate tool, but people didn't know how to use it, and now they still don't, even though it comes with instructions.

They really should have kept things separate.