4 ms·
How does no one in this thread know about power query and powerpivot? I’ve been using excel with tens of millions of rows for years now.
by nojito 6y ago
How does no one in this thread know about power query and powerpivot?
I’ve been using excel with tens of millions of rows for years now.
- fencepost 6y agoKeep in mind that for the people discussing this 10-12 years ago Excel had almost always had a limit of 64k rows. As another comment notes Excel 2007 is where that was increased to > 1,000,000. If you were a recognized person in data science you'd probably been using tools with the 64k limit for at least a decade.
- mr_toad 6y agoThe point of the quote is not about a specific technology, it’s that regardless of what technology you use if it’s limited to a single machine you’ll eventually run out of resources.
- nojito 6y agoTalking more about the thread itself. Everyone likes to use excel as a punching bag for some reason.