Bug in Excel?

[Mouimet]

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

 

[Spiky]

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.

 

[Bernard Liengme]

Not a bug but a feature.
To turn it off: Tools | Options ; open Edit tab; unselect "Extend Data Range
Formats & Formulas"
best wishes