5 ms·
The problem with Excel, in my view, is that people start using it as a database, and things get convoluted from there on very fast.
by raister 3y ago
The problem with Excel, in my view, is that people start using it as a database, and things get convoluted from there on very fast.
- cpach 3y agoIs it at that point they should upgrade to Access!? (Only half-joking…)
- rytis 3y agoI always thought of it as a datastore. What else is it? A document with one or many tables, each containing rows of highly unstructured records (that can cross reference each other), but essentially it is a data store. Or is this view completely wrong?
- withinboredom 3y agoThere have been multiple points in my life where I’ve been tasked to create a plugin for excel for essentially this purpose. It is a database though, one that is very accessible to most savvy people (aka, your domain experts) and you should lean on that instead of pushing them out. At least at smaller scales.