Copy Function into other cells

[Peco Worker]

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?

 

[Guest]

Hi

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

Andy.

 

[Peco Worker]

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

 

[Guest]

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.