Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
long term user
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.links
David McRitchie
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.links
Ken Wright
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reduce the worksheet size ? Rueben Excel Discussion (Misc queries) 3 May 25th 05 07:15 PM
Trying to enlarge tab size on worksheet for easier reading ricknstl Excel Discussion (Misc queries) 4 May 8th 05 03:41 PM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Increase rows in worksheet beyond 65,536 row limit Ann Calantzis Excel Discussion (Misc queries) 2 February 25th 05 01:33 PM
Can I split my worksheet and have different size columns and rows. tommy Excel Discussion (Misc queries) 1 February 16th 05 11:17 PM


All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"