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

Maximum number of rows in one table of Access 2000 1
how can I increase the maximum rows in an Excel worksheet? 1
More Than 65,530 Rows 3
Sorting data on two sheets 1
Increasing number of rows beyond 65K 3
Excel Macro for deleting Rows containing dates greater than "today" 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
VBA group the number in the Column and Copy to the new worksheet. 0

Top