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 38 points 6 days ago (1 children)

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 14 points 6 days ago

MyExcelDB powers thousands of institutions daily

[–] psx_crab@lemmy.zip 8 points 5 days ago

Got it.

use it as calculator

[–] Randelung@lemmy.world 9 points 6 days 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.

[–] jjffnn@feddit.dk 2 points 4 days ago* (last edited 4 days ago)

Never!

::: spoiler Spoiler YouTube link: Stand-up Maths - Stand-up comedy routine about Spreadsheets