<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
|
|