Check your import macro to see if it sets the limit at 65536. xl2007 does
exceed the old limits so the answer is some where between your code and the
source file.

" wrote:

I have a big text file to open. Excel 2007 should be able to handle
more data then the older versions. However, 2007 still only imported
65536 raws for me. (I am using Windows XP.) Does anyone know why? Is
there any way to overcome this problem? Thanks.