Why does mircosoft excel do down too the number 65536.......what is so special about this number
2007-06-19 06:22:04 · 6 answers · asked by johnp5255 1 in Computers & Internet ➔ Software
65536 is the maximum number of rows Excel can handle. As pointed out, it's 2 to the 16th power. This limit goes away in the latest version of office.
2007-06-19 06:27:07 · answer #1 · answered by jargent100 5 · 0⤊ 0⤋
This is the maximum number of line in Excel (Before Excel 2007).
Variable used in programmation are reprensented in bytes. So theres always 2^X ...
Bytes are form 0-255 (2^8)
Word are from 0-65535 (2^16)
DWord are form 0-4294967296 (2^32)
etc
So its only because they took a varible that is only able to hold a number from 1 to 65536. The new version of excel allow more rows that that.
2007-06-19 13:29:08 · answer #2 · answered by Anonymous · 0⤊ 0⤋
2^16
2007-06-19 13:24:37 · answer #3 · answered by The Master 5 · 1⤊ 0⤋
for a 16 bit binary processor, the number represents:
2^6 (or 2 raised to the 16th power)
2007-06-19 13:26:55 · answer #4 · answered by K In the House 4 · 0⤊ 0⤋
its 2^16 and that's all the memory that excel can remember
2007-06-19 13:25:58 · answer #5 · answered by FiReDoG SM 2 · 0⤊ 0⤋
More information please.
2007-06-19 13:25:03 · answer #6 · answered by micaso1971 5 · 0⤊ 0⤋