Limited amount of cells in a formula
 

I have the following formula.

COUNT(D4:D65536) which functions correctly.

a slight change

COUNT(D4:D65537) does not work.

To summarize if the range is greater than 2^16 then it seems to be
overflowing the system. The Max worksheet size is 1,048,576 rows by 16,384
columns according to the documentation so why doesn't this work and there is
a way to get it to work? Same result in Excel 2007 and 2003.
--
Tim

Limited amount of cells in a formula
 

Hi Tim,

Works fine for me in Excel 2007.

What do you mean with "doesn't work"?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tim" wrote in message ...
|I have the following formula.
|
| COUNT(D4:D65536) which functions correctly.
|
| a slight change
|
| COUNT(D4:D65537) does not work.
|
| To summarize if the range is greater than 2^16 then it seems to be
| overflowing the system. The Max worksheet size is 1,048,576 rows by 16,384
| columns according to the documentation so why doesn't this work and there is
| a way to get it to work? Same result in Excel 2007 and 2003.
| --
| Tim

Limited amount of cells in a formula
 

You are probably still in a backwards compatibility mode, which has no more than 65536 rows. Save the file as a true Excel97 file
and it should work.
Of course it won't work in Excel2003 which doesn't have that many rows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tim" wrote in message ...
|I have the following formula.
|
| COUNT(D4:D65536) which functions correctly.
|
| a slight change
|
| COUNT(D4:D65537) does not work.
|
| To summarize if the range is greater than 2^16 then it seems to be
| overflowing the system. The Max worksheet size is 1,048,576 rows by 16,384
| columns according to the documentation so why doesn't this work and there is
| a way to get it to work? Same result in Excel 2007 and 2003.
| --
| Tim

Limited amount of cells in a formula
 

<a true Excel97 file

Please read

a true Excel2007 file..............


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| You are probably still in a backwards compatibility mode, which has no more than 65536 rows. Save the file as a true Excel97
file
| and it should work.
| Of course it won't work in Excel2003 which doesn't have that many rows
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Tim" wrote in message ...
||I have the following formula.
||
|| COUNT(D4:D65536) which functions correctly.
||
|| a slight change
||
|| COUNT(D4:D65537) does not work.
||
|| To summarize if the range is greater than 2^16 then it seems to be
|| overflowing the system. The Max worksheet size is 1,048,576 rows by 16,384
|| columns according to the documentation so why doesn't this work and there is
|| a way to get it to work? Same result in Excel 2007 and 2003.
|| --
|| Tim
|
|

Limited amount of cells in a formula
 

On Wed, 2 Apr 2008 13:33:01 -0700, Tim wrote:

I have the following formula.

COUNT(D4:D65536) which functions correctly.

a slight change

COUNT(D4:D65537) does not work.

To summarize if the range is greater than 2^16 then it seems to be
overflowing the system. The Max worksheet size is 1,048,576 rows by 16,384
columns according to the documentation so why doesn't this work and there is
a way to get it to work? Same result in Excel 2007 and 2003.

No, I think the problem is that you are referencing a cell with a row number
greater than 65536.

I suspect that the file you are working in was originally created in Excel
97-2003. If you look up at the title bar, do you see [Compatibility Mode] next
to the name?

If that is the case, you can either convert the file to the new format (Press
the Office button; select Convert) or save a copy in the new format.
--ron