I used to experience the same problems importing AS/400
queries into Excel 97. When I upgraded to XL2002, I was
able to import beyond 16K+ rows into 1 sheet.

The Microsoft KB wasn't much help, but take a look anyway:

http://support.microsoft.com/default.aspx?scid=296053

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to convert a large data file from our route
accounting software
to an Excel worksheet format. Everytime I try the data
populates the
worksheet through row 16385 and stops and the remaining
data is lost. How
can I increase the Excel file size to accomodate all my
data?
.