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

Similar Threads

Insert multiple objects at once ? 3
Merging from an Excel file with graphics 1
Compressing multiple functions across an array into one cell 6
Excel - Wich Function should I use? 1
Excel --> Word 4
Need Help with a VBA subroutine 0
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

Top