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.

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)



"Pisistratus" <(E-Mail Removed)> wrote in message
news:A379BAEB-CEB3-4FF9-8DBE-(E-Mail Removed)...
> 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.
>

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

"Pisistratus" wrote:

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

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

On Jul 5, 1:42 pm, Pisistratus <Pisistra...@discussions.microsoft.com>
wrote:
> 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.