I have excel 2007 running on a 64bit windows 7 desktop.
I can not get more than 65536 rows in a worksheet.
If I try to import data from access, I only get the first 65536 rows.
Can anyone please tell me why the limit? I thought excel 2007 on a 64bit system could have more than 1 million rows.
I read in another forum that this limit applies to a 32bit system. The only thing I can think of is that I have also got excel 2003 installed on the desktop - could this be interfering?
I installed excel2003 after I had installed office2007.
Thanks for any enlightnment