3 ms·
My biggest pain point is inability (as in refusal, not failure) to open files with more than N rows even if plenty of memory is available. (I forget what the ex
by apothegm 3y ago
My biggest pain point is inability (as in refusal, not failure) to open files with more than N rows even if plenty of memory is available. (I forget what the exact value of N is.) Especially annoyingly, this limitation didn’t seem to exist 20 years ago.
- daneel951 3y agoPower Pivot Excel add-inshould be able to manage million of rows. See https://support.microsoft.com/en-us/office/data-model-specification-and-limits-19aa79f8-e6e8-45a8-9be2-b58778fd68ef https://support.microsoft.com/en-us/office/data-model-specif... and https://support.microsoft.com/en-us/office/create-a-memory-efficient-data-model-using-excel-and-the-power-pivot-add-in-951c73a9-21c4-46ab-9f5e-14a2833b6a70 https://support.microsoft.com/en-us/office/create-a-memory-e...
- apothegm 3y agoFirst off, that article seems to be specific to web versions and pivot tables. Secondly, yeah, a few million rows isn’t that much for some use cases. I have at times needed support for mid 9 figures.