Ohhhh...I see what happens. I suppose what is happening is that Excel now sees the reference to A2 in the formula as sort of disappearing. I know that doesn't make sense. Hopefully someone else will that can explain it better.

That's interesting!