Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel worksheet size - changeable?
Hi,
I'm sorry, no way to increase them. Regards, Jan Karel Pieterse Excel TA/MVP -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidation sum where ending tab value is changeable | Excel Worksheet Functions | |||
Summing across multiple sheets using a changeable reference cell | Excel Worksheet Functions | |||
How can I give text a changeable numeric value? | Excel Worksheet Functions | |||
user-changeable drop-down lists | Excel Discussion (Misc queries) | |||
Changeable Row sizes to fit in the text! | Excel Discussion (Misc queries) |