More than 1,048,576 rows

E

en67478

New member
Joined
Mar 11, 2013
Messages
5
Reaction score
0
Points
0
Hi

Quick question. Is it possible to get more than 1,048,576 rows in excel? I need about 1,600,000 rows. If yes, how?

Thanks in advance


// Esben Ploug
 
Multiple sheets.
 
Thanks

But will multiple sheets work in one pivot? All 1,6 mill rows should be working in the same pivot.
 
Yes, if you use the old pivot wizard(Alt-D-P), there is an option for multiple consolidation ranges in there.
 
You can also use Microsoft Query (which is built into Excel) to create a PivotTable without that Multiple Consolidation method. Or you can use a macro to do the same. Check out http://www.contextures.com/xlPivot08.html

And if you've got Excel 2010 - or Excel 2013 Professional - then you can use something called PowerPivot. Give google a spin for more info.
 
If the data is formatted text such as a CSV file, probably best to pull the data in with a query and work with the consolidated data using SQL statements (or use a database).
 
WizzardOfOz said:
If the data is formatted text such as a CSV file, probably best to pull the data in with a query and work with the consolidated data using SQL statements (or use a database).
Click to expand...
2010 excel version has more than what you are looking for...

Salam
 
You must log in or register to reply here.
Back
Top