How many rows a worksheet ?

[frankchang20]

Hi all,

I have a database from Access that contains about 18 columns and 170000+ rows. I need do some data analysis such as regression via Excel analysis pack. So far from what I experienced I get a feeling that Excel cannot handle so many rows in one worksheet. when I import the data it kept saying import only partial data which made me have to break down the emtire database into pieces. anyone know if there is a limit of row a worksheet allows to have, or anyway know how to reset the default row setting if there is so that I can get all my data in one worksheet?

thanks a lot!

 

[Von Pookie]

There is a limit of 65,536 rows and 256 columns per worksheet--and there is no way around it.

Until the next version of Excel comes out, at least.
http://www.mrexcel.com/board2/viewtopic.php?t=172620