65536

[ljpj707]

Anyone notice that there are only 65536 (which is one higher than the
magic 65535) rows allowed in older versions of Excel? Mabe there's
some rogue GOTO statement in the row attributes section of the code...

 

[Harald Staff]

Both my Excel 97 and my Excel 2003 (and versions between) has 65536 as a
last row. 65536 is 2^16 , a nice round binary number.
Excel 95 down and Excel 2007 up have different limitations.

HTH. Best wishes Harald

 

[JE McGimpsey]

Anybody over a certain age that ever programmed in hex or binary
certainly recognizes 65536 as 2^16.

And while the problem is very likely related to that number, it almost
certainly has *nothing* to do with "row attributes".

 

[Erich Neuwirth]

If you start numbering at 0, the largest number representablin in binary
with 16 digits you can display is 65535,
but you still can display 65536 numbers. So if internally you number the
first row with 0, you hac have 65536 rows numbered from 0 to 65535.

The same issue occurs when using either INDEX or OFFSET in Excel.

 

[Sandy Mann]

It's good to see you back in the English Newsgroups Harald, hope you stick
around more.

--
Rergards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Harald Staff]

It's good to see you back in the English Newsgroups Harald, hope you stick
around more.

This is the nicest thing I've ever read, Sandy. Thank you thank you.
I took a break from Excel and online communites when 2007 beta came.
Resulting in a miserable professional life without any fun things to do.
Trying to catch up now and learn the new version.

Best wishes Harald

 

[Gord Dibben]

Welcome back Harald.

As Sandy said.................long time no see.


Gord

 

[Peo Sjoblom]

This is the nicest thing I've ever read, Sandy. Thank you thank you.
I took a break from Excel and online communites when 2007 beta came.
Resulting in a miserable professional life without any fun things to do.
Trying to catch up now and learn the new version.

Best wishes Harald

Come on Harald, nicest thing you've ever read? I'm sure reading about all
those tons of Norwegian OL golds were more fun? <vbg> Welcome back Harald.

Peo

 

[Roger Govier]

Hi Harald

Add my good wishes to the others.
It's definitely good to see you back here.

 

[Klaus Oberdalhoff]

Hi,

Anyone notice that there are only 65536 (which is one higher than the
magic 65535) rows allowed in older versions of Excel?

http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx

explains expanded limits between 2003 and 2007 en detail

--
mit freundlichen Grüßen aus Nürnberg

Klaus Oberdalhoff (e-mail address removed)
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)
Nächstes Treffen in Nürnberg am 23.10.2007