software

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.

quot;Peco Workerquot; gt; wrote in message
...
gt;I am trying to copy a easy function, =SUM(b10-B11), into other cells in the
gt; same column and it will not work. It gives me the correct formula but it
gt; gives me the same answer as the cell copied from.
gt;
gt; So if I start with b10-b11 and then copied it down into c10-c11, it
gt; changes
gt; the formula correctly. If the answer in for b10-b11 is 50 and the anwser
gt; for
gt; c10-c11 is 45 it still answers it as 50.
gt;
gt; Has anyone else ever had this problem?
gt;
Thanks, that was it. Not sure how it got changed but it did the trick!

quot;AndyBquot; wrote:

gt; Hi
gt;
gt; Check that Tools/Options/Calculation is set to Automatic.
gt;
gt; Andy.
gt;
gt; quot;Peco Workerquot; gt; wrote in message
gt; ...
gt; gt;I am trying to copy a easy function, =SUM(b10-B11), into other cells in the
gt; gt; same column and it will not work. It gives me the correct formula but it
gt; gt; gives me the same answer as the cell copied from.
gt; gt;
gt; gt; So if I start with b10-b11 and then copied it down into c10-c11, it
gt; gt; changes
gt; gt; the formula correctly. If the answer in for b10-b11 is 50 and the anwser
gt; gt; for
gt; gt; c10-c11 is 45 it still answers it as 50.
gt; gt;
gt; gt; Has anyone else ever had this problem?
gt; gt;
gt;
gt;
gt;

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.

quot;Peco Workerquot; gt; wrote in message
...
gt; Thanks, that was it. Not sure how it got changed but it did the trick!
gt;
gt; quot;AndyBquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; Check that Tools/Options/Calculation is set to Automatic.
gt;gt;
gt;gt; Andy.
gt;gt;
gt;gt; quot;Peco Workerquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am trying to copy a easy function, =SUM(b10-B11), into other cells in
gt;gt; gt;the
gt;gt; gt; same column and it will not work. It gives me the correct formula but
gt;gt; gt; it
gt;gt; gt; gives me the same answer as the cell copied from.
gt;gt; gt;
gt;gt; gt; So if I start with b10-b11 and then copied it down into c10-c11, it
gt;gt; gt; changes
gt;gt; gt; the formula correctly. If the answer in for b10-b11 is 50 and the
gt;gt; gt; anwser
gt;gt; gt; for
gt;gt; gt; c10-c11 is 45 it still answers it as 50.
gt;gt; gt;
gt;gt; gt; Has anyone else ever had this problem?
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;