ToolsOptionsCalculation.

Make sure you are set to "automatic".


Gord Dibben MS Excel MVP

On Thu, 18 Jan 2007 19:10:00 -0800, hans wrote:

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.