Max. # of rows in a worksheet

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
 
S

SinTex

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
 
M

Mark Henri

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.
 

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

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Integrating information from Word to Excel (not mail merge) 1
Maximum number of rows in one table of Access 2000 1
Duplicates and different worksheets 0
how can I increase the maximum rows in an Excel worksheet? 1
Copying Portions of Data 0
How to delete a row in a list 2
Copy cells to different sheet if value found 1

Top