formula does not work properly

[msnarayanan]

dear sirs

i just wanted to create a work sheet in excel 2013.
the following are the columns:
(a) (b) (c) (d)


date no. of rate value
pieces

7th 10 5 50 like that

in cell (d) i entered the formula to get the value (=b3*c3)
no problem to get the correct value

but when i copy the cell d (with formula), the value is
copied and not the calculated value in the cells copied.

how to do that?

m s narayanan

[Pecoflyer]

Are calcs set to automatic?

[msnarayanan]

dear pecoflyer

i followed your suggestion and i have set calculations automatic.
it seems to work.

but to find the option screen, it takes some time.
i opened the file and then options-.formulas-worksheet etc.

this was not the case with excel 2007 which i was using earlier.

anyway, my thanks to you.

m s narayanan