Copy Function into other cells

I am trying to copy a easy function, =SUM(b10-B11), into other cells in the
same column and it will not work. It gives me the correct formula but it
gives me the same answer as the cell copied from.

So if I start with b10-b11 and then copied it down into c10-c11, it changes
the formula correctly. If the answer in for b10-b11 is 50 and the anwser for
c10-c11 is 45 it still answers it as 50.

Has anyone else ever had this problem?

Hi

Check that Tools/Options/Calculation is set to Automatic.

Andy.

"Peco Worker" <PecoWorker@discussions.microsoft.com> wrote in message
news:2915C1B5-9483-4734-8558-8149F2B6DD2E@microsoft.com...
>I am trying to copy a easy function, =SUM(b10-B11), into other cells in the
> same column and it will not work. It gives me the correct formula but it
> gives me the same answer as the cell copied from.
>
> So if I start with b10-b11 and then copied it down into c10-c11, it
> changes
> the formula correctly. If the answer in for b10-b11 is 50 and the anwser
> for
> c10-c11 is 45 it still answers it as 50.
>
> Has anyone else ever had this problem?
>

Thanks, that was it. Not sure how it got changed but it did the trick!

"AndyB" wrote:

> Hi
>
> Check that Tools/Options/Calculation is set to Automatic.
>
> Andy.
>
> "Peco Worker" <PecoWorker@discussions.microsoft.com> wrote in message
> news:2915C1B5-9483-4734-8558-8149F2B6DD2E@microsoft.com...
> >I am trying to copy a easy function, =SUM(b10-B11), into other cells in the
> > same column and it will not work. It gives me the correct formula but it
> > gives me the same answer as the cell copied from.
> >
> > So if I start with b10-b11 and then copied it down into c10-c11, it
> > changes
> > the formula correctly. If the answer in for b10-b11 is 50 and the anwser
> > for
> > c10-c11 is 45 it still answers it as 50.
> >
> > Has anyone else ever had this problem?
> >
>
>
>

Well, this option is determined by which workbook you open first in the
session. So one of your workbooks must be set to Manual, and you opened it
first today.

Andy.

"Peco Worker" <PecoWorker@discussions.microsoft.com> wrote in message
news:FE24D05B-6EAE-4EA3-909E-52025BC26EA2@microsoft.com...
> Thanks, that was it. Not sure how it got changed but it did the trick!
>
> "AndyB" wrote:
>
>> Hi
>>
>> Check that Tools/Options/Calculation is set to Automatic.
>>
>> Andy.
>>
>> "Peco Worker" <PecoWorker@discussions.microsoft.com> wrote in message
>> news:2915C1B5-9483-4734-8558-8149F2B6DD2E@microsoft.com...
>> >I am trying to copy a easy function, =SUM(b10-B11), into other cells in
>> >the
>> > same column and it will not work. It gives me the correct formula but
>> > it
>> > gives me the same answer as the cell copied from.
>> >
>> > So if I start with b10-b11 and then copied it down into c10-c11, it
>> > changes
>> > the formula correctly. If the answer in for b10-b11 is 50 and the
>> > anwser
>> > for
>> > c10-c11 is 45 it still answers it as 50.
>> >
>> > Has anyone else ever had this problem?
>> >
>>
>>
>>