worksheet size limit long term user 05.12.2005 18:57:03 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?

Re: worksheet size limit "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> 06.12.2005 04:14:57 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 user[ at ]discussions.microsoft.com> wrote in message news:93E3C4E0-63AF-497A-A3C9-7E091DB7915F[ at ]microsoft.com... [Quoted Text] > 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? >

Re: worksheet size limit "Ken Wright" <ken.wright[ at ]NOSPAMntlworld.com> 30.01.2006 23:48:20 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 user[ at ]discussions.microsoft.com> wrote in message news:93E3C4E0-63AF-497A-A3C9-7E091DB7915F[ at ]microsoft.com... [Quoted Text] > 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? >