Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|