Hi,

I've done a little checking and as best I can determine Excel 2007 allows
you to import up to 1,048,576 rows at a time and has an upper limit on the
start row of
99,999,999!

--
Thanks,
Shane Devenshire


"Linda in Wyo" wrote:

I am importing a very large csv file and when I try to set up the correct
next line for worksheet 2, I get an error "integer not valid".
Worksheet one stoped at line 65,536 but the impor editor will not let me
enter any number larger than 9999 as the next starting line.