excel, multiply problem

H

hans

I've done it a million times, taking the formula of a cell and copy that
formule to the rest of the sheet, to get the same calculation. suddenly it
doesnt work and it just copies the value of the cell I copied, not the
formalu, although it shows the formula in the cell!
can anyone help me here.
 
J

John Bundy

Are they static references such as $A$1, if so it will calculate the same no
matter where you put it
 
G

Gord Dibben

Tools>Options>Calculation.

Make sure you are set to "automatic".


Gord Dibben MS Excel MVP
 
Top