How increase max # of rows/sheet in excel?
 

I have a huge report 250,000 rows generated for me at work (John Hancock). I
use pivot tables to categorize the data. TAt this point I have to seperate
the data into 5 worksheets, create 5 pivot tables, and then aggregate them.

Is there a way to increase the maximum # of rows per sheet in excel above
the 65,000+ default? For instance to 250,000+. That would save me a
tremendous amount of time as I would only have to generate one pivot table.

Hi
no not possibe. 65536 is the maximum. Though with this much of data you
sgould consider using a database (e.g. Access) and create pivot tables using
this data

--
Regards
Frank Kabel
Frankfurt, Germany
"JKallen" schrieb im Newsbeitrag
...
I have a huge report 250,000 rows generated for me at work (John Hancock).
I
use pivot tables to categorize the data. TAt this point I have to
seperate
the data into 5 worksheets, create 5 pivot tables, and then aggregate
them.

Is there a way to increase the maximum # of rows per sheet in excel above
the 65,000+ default? For instance to 250,000+. That would save me a
tremendous amount of time as I would only have to generate one pivot
table.