Solved: Strange formula problem

[starsky]

Hi,

I'm working on a different pc to usual. I'm trying to pull a formula down a column to apply a simple multiplication formula (of the 2 columns to the left), but I'm getting the same result in each cell even though different values appear on each row. E.g. in C2 formula might be A2*B2 with result of '10'. If I pull this down I will have the correct formula in C3, but the result will be '10' again, even though that is the incorrect answer.

I am bemused to say the least.

Any ideas?

Thanks

[BobBarker]

Can you post a sample worksheet?

[mdmackillop]

Check that Calculation is set to Automatic.

[starsky]

That was it, thank you.