4 ms·
Excel 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 utilit
by tomnipotent 5y ago
Excel 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 :)