Re: Stupid Question
Posted by Mike Quone on December 18, 2001 11:24 AM
Why are there only 65,536 rows in a excel worksheet, actually ... same as the number of workstations in an A-class network, same as the number of colors, same as 64MB RAM ... where did they get that number?
Posted by Mike Grady on December 18, 2001 11:31 AM
I think is has to do with 2 to the 16th power - the number of unique descriptions a list of 16 0's and 1's can denote.
Posted by Jack on December 18, 2001 11:31 AM
Just few days ago a master mind answered that look lower down and yoy shoulf find the post, all about binary addresses and so, very cleaver
Posted by Mark W. on December 19, 2001 2:13 PM
1,024 x 64 = 65,536 (nt)
Posted by Jack on December 19, 2001 3:17 PM
Re: 1,024 x 64 = 65,536 (nt)
Mark W
Comments like that need explaining, im intrested, that appeals to me - ill be glad if you let me know
Cheers Mark
Jack in UK
Posted by Mark W. on December 20, 2001 7:13 AM
Re: 1,024 x 64 = 65,536 (nt)
1,024 is the decimal equivalent for 1 kilobyte.
The row limit is determined by a design rule
based on 64 KB. Since Excel worksheets must be
memory resident there must be a limit to their
size. This limit was last increased from 32,768
as PCs came equipped with more RAM. Needless to
say, changing this design rule has implications
for the backward compatiblity of worksheets;
therefore, a change in this limit is always slow
in coming. I suspect that there is little
"pressure" to increase this limit now that there
are alternatives (Get External Data and PivotTables)
to access greater amounts of data.
