Maximum no of rows in Excel

K

kalz

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
 
J

JulieD

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
 
M

MikeY

Max number of rows: 65536 for Excel 97 or newer
Max number of rows in Pivot table: Depend on the memory remained
 

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

Top