Errors in copying formulas
 

When I copy a formula from one cell for set row to the following rows' cells
I get the same result as the original cell although the formulas are changing
as they should. I am not using absolute references in the formula. I have
never seen this before while working with excel.

ToolsOptionsCalculation.

Make sure "Automatic" is checked.

Gord Dibben Excel MVP

On Sat, 11 Dec 2004 15:03:02 -0800, "Frequent_User"
wrote:

When I copy a formula from one cell for set row to the following rows' cells
I get the same result as the original cell although the formulas are changing
as they should. I am not using absolute references in the formula. I have
never seen this before while working with excel.