Drag formula down

T

TxVics

Has anyone had a problem where dragging a formula down, and the new cells
display the value from the original cell even though the formula itself is
correct? If I clear the cell and reenter the formula, it calculates
correctly.

Thanks!
 
M

MDubbelboer

your calculation is probably set to manua

you have to press f9 to calculat

go to tools->options->calculation and change it to automatic for it t
update automaticall

mar
 
Top