Excel - Paste Error

[GUIDO22]

I have two columns of figures - I create a third column, the cell for which contains a simple formula of 2nd column val minus the first column val. The result is correct for the first row. If I then copy and paste the formula for the remaining rows they all receive the formula correctly incremented for each row/col, but the cell value is that of the first row i.e. the cells are not calculating correctly. Why is this?

I have not seen this problem before.....?????

TIAFYH

G

 

[qafself]

Have you checked calculation is not set to manual?

Tools > options > calculation - make sure auto is set.

 

[GUIDO22]

Thanks - that was it! I did notice after posting the comment that the cell values would update on SAVE..... not sure why this option has switched off - as the AUTO formula update feature was working last week.... Thanks for your help!