Max. # of rows in a worksheet

  • Thread starter Thread starter Manish Patel
  • Start date Start date
M

Manish Patel

Does anyone know what is the maximum number of rows a
worksheet can handle and if there is a way to increase it?
We are on Excel 2000.

We have a need to prepare a worksheet with around 95000
rows.

Any help is appreciated,

TIA,
Manish Patel
 
you can go into excel help and search specifications.. total rows wil
be there... i have excel 2002(xp), 65536.. i don't think you can ad
more then this amount to a single sheet... span the table accross tw
worksheets

SinTe
 
We have a need to prepare a worksheet with around 95000
rows.
Click to expand...

Consider Access and a reporting front end like Crystal Reports. Access
tables can handle 4.2 billion records.
 
Back
Top