Excel - paste special formulas doesn't work

[beruf3]

I have Excel 2007, when I paste special formulas from one cell (let's say A1) to all other cells in A column,
it copies formulas OK, but it shows value of what formula calculated for A1. Then, I need to go to every single cell and press "Enter" to get the correct value.

 

[beruf3]

I found it myself. Calculation options were changed to "manual". I don't know how. But I switched it back to "automatic".