4 ms·
I'm sympathetic, especially given this was core infrastructure for a nationwide emergency. But, how many people do actually know the row limit? It's easy to say
by dash2 6y ago
I'm sympathetic, especially given this was core infrastructure for a nationwide emergency. But, how many people do actually know the row limit? It's easy to say experts know it. But is it discoverable from within the interface? If you're a management consultant Excel jockey, is there a way you would have learned about this before tripping over it?
- protomyth 6y agoI do believe there is a huge warning when you do the import. I will verify when I get to work.
- protomyth 6y agoTried to open a 2 million row file and got an error dialog that must be clicked to continue with the text "Alert File not loaded completely." Excel's limits https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 https://support.microsoft.com/en-us/office/excel-specificati...
- NicoJuicy 6y agoIt's literally on the first thing that pops up when you search for "limitations excel". A consultant should know his tools, that's what you pay him for.