Scott Klement's open source interface to the POI HSSF/XSSF Spreadsheet Project for RPG Programmers. http://www.scottklement.com/poi/
Okay, I updated it to use the 2-500 (e.g. =SUMIF(D$2:D$500,BJ4,J$2:J$500)/2000) in the formula and the number of rows that contain data are through 575 and still the same thing, the formula doesn't execute until I click on it and press Enter. Hmmm... very peculiar. With this change some of the formulas now contain a value of zero since the data is only available through to row 500, but that is to be expected.