Peter

ToolsOptionsCalculation.

Checkmark "Automatic".

Gord Dibben Excel MVP

On Mon, 17 Jan 2005 07:39:42 -0800, "Peter Kristensen"
wrote:

I have experienced a problem new to me. A have a row of
figures that I want to divide with 1000. I do as I
usually do +CELL/1000 in a new row. When I want to drag
the formula down to the rest of the row, I get the same
number in all cells, but the reference looks OK. If I do
it "manually" in all cells it works ...

Does anybody know what could be wrong ?