## trouble with formulas

### Re: trouble with formulas

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.

### Re: trouble with formulas

Does anyone have any insight on why this occurring? Shouldn't the formulas work once you open up the spreadsheet or am I missing something.

Thanks for your input.

Thanks for your input.

### Re: trouble with formulas

Just to give full disclosure: I found that the spreadsheet needed to be updated to force formula calculations when opened. The way I did this was to right click on a tab and then "View Code". Once that opened, I clicked on "ThisWorkbook" and found the attribute "ForceFullCalculation" was set to "False", so I changed it to "True" and saved the spreadsheet and voila it worked like a charm.

Thanks everyone for your input.

Thanks everyone for your input.