My MS Excel..
 

Is going stupid...

when I drag and drop my formula down a column, it wouldn't update to the correct figures (it copied down the result of the first cell) unless I hit F9 to update it..

It didn't use to do that... Anyone know what could be wrong?

It started since I exported some data from an accounting program to Excel...

I use excel 2007..

The only time I've encountered a problem like yours is when I used something involving a random number generator function. I would copy the random number generator function down and you would have to hit F9 to make the numbers regenerate themselves.

I'm guessing you're using a slightly more complicated function?

I'm pretty sure I've never had it with any of the more standard functions.

it was just Column A minus Column B... T_T

It's happening to all my Spreadsheets now.. even old ones that use to be fine...

Might need to google a solution later...

Hm. I can't visualize why that might happen.

Ohhh I found it..

Apparently under Formulas there's a Calculation option that I can choose automatic or manual.. it got flicked to manual by itself..

should be fixed now... Thx!