More than 1,048,576 rows

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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Multiple sheets.
 

en67478

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

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

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Yes, if you use the old pivot wizard(Alt-D-P), there is an option for multiple consolidation ranges in there.
 

JeffreyWeir

Super Moderator
Staff member
Joined
Mar 22, 2011
Messages
357
Reaction score
0
Points
0
Location
New Zealand
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.
 

WizzardOfOz

New member
Joined
Sep 4, 2013
Messages
184
Reaction score
0
Points
0
Location
Australia
Excel Version(s)
Office 365
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

New member
Joined
Nov 17, 2012
Messages
7
Reaction score
0
Points
0
Location
GTA
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
 
Top