M

#### MJS

I'm using Excel 2007. Excel is "supposed" to default to copying formulas

into inserted rows by default (assuming previous rows have the same formula).

I've also ensured the option to Extend data range formats and formulas is

checked in [Windows Symbol]->Excel Options->Advanced.

My formulas are not being copied to the inserted row and one formula in the

row below where a relative reference to the row above is not adjusted

correctly (i.e. a simple "=A5" for row 6 on insert remains "=A5" rather than

adjusting to "=A6").

So two different problems but both occurring when I try to insert a row.

Any idea why this isn't working properly?

MJS