Not a bug but a feature.
To turn it off: Tools | Options ; open Edit tab; unselect "Extend Data Range
Formats & Formulas"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mouimet" wrote in message
...
Hi,
Using a simple formula "SUM" the formula change himself
Test this anywhere in a sheet: For this example I will use A1 to A15
In cells A16 type: =sum(A1:A10)
In Cells A17 Type: =sum(A11:A15)
Now start to type number 1 in cell A1 than A2 and so on.
The sum in cell A16 are ok until you reach A10
If you type 1 in row A11 the sum in cell A17 show 1 and now the formula in
cellA16 change himself and show 11 instead of 10.
a1 1
a2 1
a3 1
a4 1
a5 1
a6 1
a7 1
a8 1
a9 1
a10 1
a11 1
a12
a13
a14
a15
11 This is at the beginning =sum(A1:A10) After entering the 1 in the cell
A11 the formula change
1 This is at the beginning =sum(A11:A15)

Do you have a patch for this or this is new ?
Bye