Home

Process the big data

%3CLINGO-SUB%20id%3D%22lingo-sub-1264576%22%20slang%3D%22en-US%22%3EProcess%20the%20big%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264576%22%20slang%3D%22en-US%22%3E%3CPRE%3E%3CSPAN%3EI%20process%20data%20with%20a%20size%20that%20is%20quite%20large%2C%20namely%20the%20number%20of%20lines%20up%20to%20hundreds%20of%20thousands.%20I%20am%20currently%20constrained%20because%20the%20number%20of%20rows%20is%20only%20up%20to%2064612%20rows.%20How%20to%20set%20so%20that%20the%20number%20of%20rows%20can%20be%20even%20greater.%20Thanks.%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1264576%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1264851%22%20slang%3D%22en-US%22%3ERe%3A%20Process%20the%20big%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F600946%22%20target%3D%22_blank%22%3E%40yoepls%3C%2FA%3E%26nbsp%3BI%20am%20guessing%20that%20you%20have%20an%20older%20version%20of%20Excel.%26nbsp%3B%20Versions%20from%202007%20onwards%20have%201%2C048%2C576%20rows%2C%20and%20with%20the%20Power%20Query%20add-in%20can%20handle%20even%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
I process data with a size that is quite large, namely the number of lines up to hundreds of thousands. I am currently constrained because the number of rows is only up to 64612 rows. How to set so that the number of rows can be even greater. Thanks.
1 Reply
Highlighted

@yoepls I am guessing that you have an older version of Excel.  Versions from 2007 onwards have 1,048,576 rows, and with the Power Query add-in can handle even more.