Large ranges

This page in 2003
Top  Previous  Next

The expression SUM(A1:Z1000) is just 12 characters long, but it mentions 26,000 cells.  Encountering such a term in a formula will cause an explosive fan-out in a discrepancy analysis.

OAK therefore provides the means to specify a limit beyond which formulas have terms that mention lots of cells are not further processed in a discrepancy analysis.

Click to enlargeDiscrepancy analysis range size limit

If this facility is enabled, and the default limit of 500 cells accepted, then the addresses mentioned in a range of up to 500 cells will be included in a discrepancy analysis (and, potentially, their precedents also); but ranges involving more cells will not be included in the analysis.