1. It happens to one of my Worksheets.
2. When the Worksheet gets relatively large (but still a tiny
percentage compared to 256 X 65536 cells available), it happens that
one of the (last) cells is not updated. That's rather noticeable when
the worksheet is being tested. Otherwise, how could one readily
anticipate an error (out of the many wonderful things that Excel can
do, an error such as a missed calculation is the least expected) ?
3. The lesson learnt is that there are too many formulae deployed on
the worksheet albeit it's hardest to tell how many would tentatively
become too many.
4. Also, the array formulae are long and winding hence, complicated.
Filled-down in a column, the formulae work well in other cells except
one (as mentioned above).
5. Neutrally speaking, there's apparently a case of overburden imposed
upon the part of you-know-what.
6 Regards.