| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching a limited amount of rows in a vertical array | Excel Discussion (Misc queries) | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
| populate a limited # of cells with a set value | Excel Worksheet Functions | |||
| Limited amount of labels in exces | Excel Worksheet Functions | |||
Threaded Mode
