| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I add additional rows beyond the 65,536 in excel 2003
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add additional rows beyond the 65,536 in excel 2003
No, the number of rows is fixed at 64K.
"pbhatt07" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add additional rows beyond the 65,536 in excel 2003
Hi Wait until the Release of the next version of Excel (currently known as Excel 12). That will have 1048576 rows and 16384 columns. You will have all your problems resolved. Best regards Deepak Agarwal -- agarwaldvk ------------------------------------------------------------------------ agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345 View this thread: http://www.excelforum.com/showthread...hreadid=533560 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add additional rows beyond the 65,536 in excel 2003
Thanks, I appreciate it. when will that be released? what can i do in the
meantime? "agarwaldvk" wrote: Hi Wait until the Release of the next version of Excel (currently known as Excel 12). That will have 1048576 rows and 16384 columns. You will have all your problems resolved. Best regards Deepak Agarwal -- agarwaldvk ------------------------------------------------------------------------ agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345 View this thread: http://www.excelforum.com/showthread...hreadid=533560 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add additional rows beyond the 65,536 in excel 2003
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 "pbhatt07" wrote: Thanks, I appreciate it. when will that be released? what can i do in the meantime? "agarwaldvk" wrote: Hi Wait until the Release of the next version of Excel (currently known as Excel 12). That will have 1048576 rows and 16384 columns. You will have all your problems resolved. Best regards Deepak Agarwal -- agarwaldvk ------------------------------------------------------------------------ agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345 View this thread: http://www.excelforum.com/showthread...hreadid=533560 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add additional rows beyond the 65,536 in excel 2003
Spread your data out over more than one worksheet?
Gord Dibben MS Excel MVP On Mon, 17 Apr 2006 14:50:02 -0700, pbhatt07 wrote: Thanks, I appreciate it. when will that be released? what can i do in the meantime? "agarwaldvk" wrote: Hi Wait until the Release of the next version of Excel (currently known as Excel 12). That will have 1048576 rows and 16384 columns. You will have all your problems resolved. Best regards Deepak Agarwal -- agarwaldvk ------------------------------------------------------------------------ agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345 View this thread: http://www.excelforum.com/showthread...hreadid=533560 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add additional rows beyond the 65,536 in excel 2003
It is intended to be released sometime in 2007. Best regards Deepak Agarwal -- agarwaldvk ------------------------------------------------------------------------ agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345 View this thread: http://www.excelforum.com/showthread...hreadid=533560 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I read over than 65,536 rows from excel spreed sheet | Excel Discussion (Misc queries) | |||
| Excell VS Office | Excel Discussion (Misc queries) | |||
| How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
| how do I unhide Excel 2003 spreadsheet rows with usual method. | Excel Discussion (Misc queries) | |||
| Excel should allow more than 65,536 rows. | Excel Discussion (Misc queries) | |||
Hybrid Mode
