I was NOT suggesting that you should turn autocalculation off. I was asking if it was. Sorry if I confused you with that.

When you copy if to another column, does the formula still point to column B?
=LEN(B4)-LEN(SUBSTITUTE(B4,"2",""))

You might want to replace B with $B