How to convert a static formula to dynamic formula ?

[Guest]

I'm using relative referencing, but what exactly happening is when I copy the
formula i.e =A1+B1 from Cell C1 to Cell C2, the formula copied in Cell C2 is
=A2+B2 as expected, but the value is of Cell C1 i.e value of =A1+B1. why is
the value not changing ?

I'm aware of absolute referencing and i've checked for the $ sign in the
formula and there aren't any.

 

[Bob Phillips]

Check that you don't have manual calculation set, Tools>Options>Calculation,
there are option buttons for Automatic and Manual.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

probably it is not the referencing but that you need to go to
tools>options>calculations> and select automatic.

 

[Pete_UK]

You probably have the sheet set to manual calculation - press F9 to
force a re-calculation. Go to Tools | Options | Calculation tab and
check Automatic and OK.

Hope this helps.

Pete