Bug in Excel?
 

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

Bug in Excel?
 

On Nov 14, 12:16*pm, Mouimet
wrote:
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

It's part of the automatic entry features. So it's a "feature", not a
"bug". Excel will automatically fill new formulas in empty cells in a
database, too, if you have it setup properly.

Bug in Excel?
 

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