> Excel is really good for the wizards and for that one spreadsheet full of macros written by a wizard, which thus can't be ported over to Libreoffice or anything else. Many of those probably should Just™ be made into actual databases, but Excel is a lot more approachable than those, so you end up with giant spreadsheets instead.
Yes!! Misusing Excel as a database is really part of the problem. It also causes so many issues. Having multiple data elements within one cell. Someone overtyping a formula in a column of 200.000 values leading to one cell no longer being updated. Needing 32GB of RAM just to edit a spreadsheet with a measly 500.000 rows.
All stuff that never would happen with a real database. Microsoft never really put much effort into making Access approachable.
Yes!! Misusing Excel as a database is really part of the problem. It also causes so many issues. Having multiple data elements within one cell. Someone overtyping a formula in a column of 200.000 values leading to one cell no longer being updated. Needing 32GB of RAM just to edit a spreadsheet with a measly 500.000 rows.
All stuff that never would happen with a real database. Microsoft never really put much effort into making Access approachable.