3 ms·
> we came up against the 65536 rows limit At which point you have a database and would be better served with a different product designed to work with large da
by kevin_thibedeau 12y ago
> we came up against the 65536 rows limit
At which point you have a database and would be better served with a different product designed to work with large data sets or moving data to external ODBC sources that Excel can query.
- ZenoArrow 12y agoThat only works if you have the IT infrastructure to support it. In the company I was referring to before, the IT team was effectively one guy. Plus, there was a considerable Excel expertise in the team I was in at the time, aside from calculation time Excel was working very well for what was needed.
- davidgerard 12y agoThis is true but empirically, nobody cares: they're gonna do it in a spreadsheet. So spreadsheet software has to allow for this massive use case, and arguing they're doing it wrong gets no traction.