Re:Ask HN: What are your most common tasks and painpoints in...
by apothegm on Monday January 15, 2024 @10:55AM
(#39002256)
First 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.
See https://support.microsoft.com/en-us/office/data-model-specif... and https://support.microsoft.com/en-us/office/create-a-memory-e...