Limited amount of cells in a formula

[Tim]

I have the following formula.

COUNT(D465536) which functions correctly.

a slight change

COUNT(D465537) 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.

 

[Niek Otten]

Hi Tim,

Works fine for me in Excel 2007.

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have the following formula.
|
| COUNT(D465536) which functions correctly.
|
| a slight change
|
| COUNT(D465537) 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

 

[Niek Otten]

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

|I have the following formula.
|
| COUNT(D465536) which functions correctly.
|
| a slight change
|
| COUNT(D465537) 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

 

[Niek Otten]

<a true Excel97 file>

Please read

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|
||I have the following formula.
||
|| COUNT(D465536) which functions correctly.
||
|| a slight change
||
|| COUNT(D465537) 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
|
|

 

[Ron Rosenfeld]

I have the following formula.

COUNT(D465536) which functions correctly.

a slight change

COUNT(D465537) 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