Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can i increase number of rows beyone 65536 in excel sheet
the maximum of number of rows that are available in an excel sheet are only
65536,i would like to enhance it to my choice. Plase mail me how can i do it ,either by writing a macro , or other way. please also mail me the entire procedure, where to correct and where to run the macro etc. |
#2
|
|||
|
|||
You want the car washed and the dog taken out as well?
There is no way of extending this, use a database or multiple sheets -- Regards, Peo Sjoblom "increasing number of rows in excel sheet" <increasing number of rows in excel wrote in message ... the maximum of number of rows that are available in an excel sheet are only 65536,i would like to enhance it to my choice. Plase mail me how can i do it ,either by writing a macro , or other way. please also mail me the entire procedure, where to correct and where to run the macro etc. |
#3
|
|||
|
|||
Don't think there's any way to do this <g
The 65536 rows is a limitation in Excel -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "increasing number of rows in excel sheet" <increasing number of rows in excel wrote in message ... the maximum of number of rows that are available in an excel sheet are only 65536,i would like to enhance it to my choice. Plase mail me how can i do it ,either by writing a macro , or other way. please also mail me the entire procedure, where to correct and where to run the macro etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should accomodate more number of rows than 65536, to load l. | Excel Discussion (Misc queries) | |||
How do I increase the limit on the number of import rows in Excel | Excel Discussion (Misc queries) | |||
Can I increase row capacity beyond 65536 rows | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
increasing the number of rows of a worksheet beyond 65536? | Excel Discussion (Misc queries) |