View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Spinks Matthew Spinks is offline
external usenet poster
 
Posts: 2
Default Excel worksheet size - changeable?

Please can someone advise whether the workbook row limit
of 65536 is hard-coded to the program or if it is possible
to change this? I'm guessing there is some clever way of
changing but it is restricted to prevent huge potential
volume crashing a pc? I have a few files that are around
100k lines long and at present I work on them in two parts
which is a little frustrating sometimes.

Many thanks.