ExcelBanter - Copying formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copying formulas (https://www.excelbanter.com/excel-discussion-misc-queries/4002-copying-formulas.html)

Peter Kristensen

Copying formulas

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 ?

Gord Dibben

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 ?

All times are GMT +1. The time now is 08:15 AM.