Fill handle and formula settings wrong?

[Dragon_Claw]

Lately, my fill handle has gone off the rails. I used to double click on the little arrow and the rest of the column would get the formula.

Now it just copies the data(using the same formula). I don't keep absolute refrences, but the data is "copied", even though the formula and refrences are different.

If I paste with formatting only, it will erase the cell with the data that was just "copied".

It used to work just fine, what's going on?

[#2]

Also, with the "copied" formula (referencing different cells for data), if I go down the column or row, open the formula, and push enter, it will now display the proper information.

[#3 · Accepted solution]

Check on ribbon if Formulas->Calculation Options is set to Automatic

[#4]

Yes, this is it! Thanks so much!