How increase max # of rows/sheet in excel?

G

Guest

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

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot using 250,000 rows of data in Excel? 1
how do I increase maximum worksheet size in Excel? 2
Question on the occupied field of the pivot table in excel spreadsheet 0
How to increase the maximum rows in the worksheet? 4
how to increase no. of rows in excel spreadsheet 2
Pivot table has bloted file size - how do I bring it down 2
how to increase the max number of rows in Excel spreadshee above 6 2
The increase number of rows in Excel 12

Top