Copied formula produces unexpected copied results

[Robert]

My supervisor is working in excel 2007 and copied and pasted a formula down a
range/column of cells. The formula looks right but it posts the same results
as the cell the formula was copied from. For example Cell A1 is 25, A2 is 25,
A3 is =sum(A1+A2) showing 50. Copying that formula down the 3rd column posts
the correct formula ie =sum(B1+B2), =sum(C1+C2). The information for exampe
in B1 is 30, B2 is 30, C1 is 40 & C2 is 40 but the B3 and C3 are showing as
50. The same information as cell A1. This continues on down the page. If you
go back and manually retype the formula, the results are corrected, showing
B3 is 60 and C3 is 80. This problem is affecting every file sent to her from
either 2003 or 2007 and even in new workbooks that she opens. It doesn't
matter if she is copying across a row or down a column. Any Ideas?

 

[Roger Govier]

Hi Robert

Sounds like calculation mode has got set to Manual.
Press F9 to recalculate and all the values should change

To alter the setting, Tools>Calculation>Automatic.

Calculation mode gets set by the first workbook opened in that Excel
session. Your Supervisor needs to take a look at that workbook, alter it's
setting as well and save it, else the same thing is likely to happen again.