Because Excel is actually pretty awful software. But! You can use it as a database and application and hack something together and throw it on a shared drive somewhere.
If you lose that second stuff, there's no reason left to use Excel.
it also doesn't work with some of her old workbooks or with her mom's copy of excel
I mean, it gets the job done but nothing is convenient. The UI looks like a Christmas tree and still everything you need to do is found several sub-menus down in confusing dialogs, like in Excel pre-ribbon times. And for the love of god, please don’t say that ribbon spoiled everything, that discussion was boring even 10 years ago. Since then, state of the art has evolved beyond that.
For small scale household data, the web version of excel is good enough and has an easier UI. For larger scale, duckdb and some python.
I switched to OnlyOffice even though its capabilities are extremely limited for any non-trivial use case.
It's my daily driver ever since...
> ribbon spoiled everything