Thread: 65000 limit
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 65000 limit

Yes, it has 1 million rows, give or take a couple thousand.

Dave
--
Brevity is the soul of wit.


"Jim May" wrote:

FYI: Excel 2007 (I heard) exceeds the 65536 rows quite a bit!!

"Ven" wrote:

Hi
I often produce csv files that exceed the 65000 row limit in Excel.
Can someone point me to a solution that will either split the files in
65000 lime bites or is there a macro to import into Excell by filling limit
of cols and then move across and down the next vacant rows and so on.
A shell script would be fine too.
thanks, Ven