4 ms·
isn't excel limited to just over a million rows?
by jjtheblunt 5y ago
isn't excel limited to just over a million rows?
- tomnipotent 5y agoExcel 2013 and later has a columnar database capable of handling millions of rows, but not through the standard sheets interface so it loses a lot of the utility people are used to.
- jodrellblank 5y agoHow? Through what interface, or by what feature name to Google?
- easton 5y agoExcel refers to it as the “Data Model”. It allows joining tables/sheets and referencing them from other tables. https://www.microsoft.com/en-us/microsoft-365/blog/2012/08/23/introduction-to-the-data-model-and-relationships-in-excel-2013/ https://www.microsoft.com/en-us/microsoft-365/blog/2012/08/2...
- jodrellblank 5y agoThanks :)
- blowski 5y agoYes, although you can have multiple sheets each with a million rows. Kind of like sharding. But I’d be fascinated what kind of system spec is required to get good performance on those kind of numbers. I’ve been on a Mac for years, where Excel is crippled by limitations.
- LegitGandalf 5y agoWorking with a Mac for the first time this year, excel on Mac is actually worse than excel 2010 :(