P
pbhatt07
I am working with a list that contains greater than 65,536 rows. is there
any way I can add rows to a standard workbook?
any way I can add rows to a standard workbook?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
No, the number of rows is fixed at 64K.
A
agarwaldvk
Hi
Wait until the Release of the next version of Excel (currently known a
Excel 12). That will have 1048576 rows and 16384 columns. You will hav
all your problems resolved.
Best regards
Deepak Agarwa
Wait until the Release of the next version of Excel (currently known a
Excel 12). That will have 1048576 rows and 16384 columns. You will hav
all your problems resolved.
Best regards
Deepak Agarwa
P
pbhatt07
Thanks, I appreciate it. when will that be released? what can i do in the
meantime?
meantime?
M
Michael M
Hi
One option is to spread your data over a number of sheets, and then use a
summary sheet at the end to do stuff like totals, averages, etc.
Remember, the 65,536 is a limit on each sheet, not the entire workbook.
HTH
Michael
One option is to spread your data over a number of sheets, and then use a
summary sheet at the end to do stuff like totals, averages, etc.
Remember, the 65,536 is a limit on each sheet, not the entire workbook.
HTH
Michael
G
Gord Dibben
Spread your data out over more than one worksheet?
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
A
agarwaldvk
It is intended to be released sometime in 2007.
Best regards
Deepak Agarwal
Best regards
Deepak Agarwal