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.
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
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.
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.
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
MyExcelDB powers thousands of institutions daily
Got it.
use it as calculator
Never!
Spoiler
YouTube link: Stand-up Maths - Stand-up comedy routine about Spreadsheets
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.