dragging formula copies values instead

[icestationzbra]

hi,

i have been experiencing a strange occurence in my workbook which i
replete to the hilt with macros.

when i enter a formula in a cell and drag it down, it copies the value
down the column, instead of the formula. that is, if the value of th
formula for a particular row is 225, it copies 225 down the whol
column irrespective of what the result of the formula may be for an
other row. i have checked and dont seem to find a reason for it.

however, when i click F9 to recalculate, it shows the recalculates th
formula and shows the correct values.

could there be a logical explanation and hence a solution?

thanks,

mac

 

[icestationzbra]

hi,

i found a way to solve the problem.

went to TOOLS-OPTIONS-CALCULATION and set CALCULATION to automatic
that seems to have taken care of the problem.

thanks,

mac

 

[Peo Sjoblom]

You must have the calculation set to manual under tools>options>calculation