Formula Showing First Row Results Only

[dpmaki]

Below is just a simple example of what is occurring for me in Excel.

[TABLE="width: 193"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Number1[/TD]
[TD]Number2[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]72[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
</tbody>[/TABLE]


The Total column is my formula (=sum(a1+b1) in row 1, =sum(a2+b2) in row 2 etc.). When I copy the formula down it shows 18 as the results for each row even though that's clearly not the case. Any ideas what is going on here? This just started to happen the other day.

 

[richardbird]

Either the excel workbook calculation mode is set to manual (=> change it to automatic) or you fixed the row with a $.