Maximum no of rows in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

Working on a large file of data, wondering what is the max. rows in excel it
can handle? Also, the maximum rows in Pivot table?

thx,
Kalz
 
Hi Kalz

maximum rows per worksheet is 65536
and according to help the number of row fields in a pivot table is limited
by available memory

check out Excel Specifications and Limits in help

Cheers
JulieD
 
Max number of rows: 65536 for Excel 97 or newer
Max number of rows in Pivot table: Depend on the memory remained
 
You must log in or register to reply here.

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

add restriction in Excel 3
Pivot using 250,000 rows of data in Excel? 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Excel maximum Row number 2
Find the maximum value in a row or column with text and numbers 2
Trying to find additional ranges outside of min, max, and average 2
Excel Pivot Table How to Sort data as Percent of Row 12
Lookup Value in Table 8

Back
Top