I have a spreadsheet that automatically fills in calculating cells when others on the row are filled in. Not sure how and when this happened but some calculating cells don't get filled in automatically.

Why is that?

I think it might have to do with the fact that the last cells are calculated on cells that are automatically filled in. Can Excel not automatically fill in cells after the previous cells have automatically filled in?