My MS Excel..

**Hessah** · 07-20-2010, 02:34 AM

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..

**Ralath** · 07-20-2010, 02:40 AM

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.

**Hessah** · 07-20-2010, 02:43 AM

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...

**Ralath** · 07-20-2010, 02:45 AM

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

**Hessah** · 07-20-2010, 02:48 AM

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!