How increase max # of rows/sheet in excel?

J

JKallen

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

PivotTable - Filter Row 0
Excel 2002: What happen to the extra rows and columns ? 1
Connection files and pivot tables 0
How DO I Increase The Excel Cell Comment Data Capacity? 1
Excel Pivot Table row heading (blank) with no data in it 3
Excel freezes while Inserting rows in a pivot table (custom vba co 0
Getting "Per Item" Pivot Chart Results when data rows are identica 4
Help with pivot table 1

Top