More than 1,048,576 rows

[en67478]

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

[Bob Phillips]

Multiple sheets.

[en67478]

Thanks

But will multiple sheets work in one pivot? All 1,6 mill rows should be working in the same pivot.

[Bob Phillips]

Yes, if you use the old pivot wizard(Alt-D-P), there is an option for multiple consolidation ranges in there.

[en67478]

Thank you so much i'll try it

[JeffreyWeir]

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.

[en67478]

Thank you JeffreyWeir

[WizzardOfOz]

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).

[Salam]

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).

2010 excel version has more than what you are looking for...

Salam