When I copy a formula to other cells, it displays the data ....

J

jay

in the field I copied from. I did NOT use absolute in the formula. If I
double click on the cell with the incorrect data then press enter, the data
is updated and correct. What is going on here, I have never had this happen
before?

Thanks in advance to any answers...
 
D

duane

you need to turn caculation on to automatic. go to tools, options
calculation and select automatic
 
Top