Copy formula not working?!

[Guest]

Hi there,

I have inherited a worksheet, that seems to be doing something rather odd...

Lets say there is data in column A, I now enter a simple subtraction formula
in cell A1 and the result is 12. If I copy this formula down a few rows, 12
apears as the result in all cells (which is not the correct answer, but
rather a value that has been copied).

What is more intesting is if I then click into cell A2 and press 'Enter' the
forumla is shown as expected. Then when I navigate awat from cell A2 the
correct answer appears!

I have tried various formatting, and checks but I can seem to resolve this.

Any ideads please.....

 

[Pete_UK]

You probably have manual recalcuation set for this workbook. Go to
Tools | Options | Calculation tab and click on Automatic recalcuation.
You can also press F9 to recalculate a sheet set to manual.

Hope this helps.

Pete

 

[Guest]

Check Tools=>Options=>Calculation-->Automatic (not Manual)

 

[Guest]

Excellent, thank you very much. Great tip about F9 too.

 

[Pete_UK]

Thanks for feeding back - glad to be of help.

Pete