Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
worksheet size limit
Why are the cells limited to 256 columns and 65,536 rows? Once a format is
set and then you realize its limits, its too late and too cumbersome to reorganize the sheets. Are there any future restructuring of these limits to a more even distrubution of rows and columns (30,000 X 30,000) by Microsoft? |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
worksheet size limit
Because machines were not designed in the year 2005, and
early machines could not even address 32768 positions in memory let alone cells. Next year (2006 or 2007 in Microsoft terms) you will have more capability in Excel 12. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "long term user" <long term wrote in message ... Why are the cells limited to 256 columns and 65,536 rows? Once a format is set and then you realize its limits, its too late and too cumbersome to reorganize the sheets. Are there any future restructuring of these limits to a more even distrubution of rows and columns (30,000 X 30,000) by Microsoft? |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
worksheet size limit
It will not be square, but both values will increase considerably in the
next version. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "long term user" <long term wrote in message ... Why are the cells limited to 256 columns and 65,536 rows? Once a format is set and then you realize its limits, its too late and too cumbersome to reorganize the sheets. Are there any future restructuring of these limits to a more even distrubution of rows and columns (30,000 X 30,000) by Microsoft? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reduce the worksheet size ? | Excel Discussion (Misc queries) | |||
Trying to enlarge tab size on worksheet for easier reading | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Increase rows in worksheet beyond 65,536 row limit | Excel Discussion (Misc queries) | |||
Can I split my worksheet and have different size columns and rows. | Excel Discussion (Misc queries) |