How to prevent function range auto-modification ?

[Manuel]

Hi,

I've discovered a feature that I find quite anoying: when I write
something in a cell next to a range of cell used in any function, this
range is changed automatically to include the written cell.

Example:

1) Open a new workbook
2) Enter the numbers 1 in cell A1, 2 in B1 and 3 in C1
3) Enter the function "=SUM(A1:C1)" in cell F1

Now enter any number in cell D1: Excel changes the range of the SUM
function in cell F1 from "A1:C1" to "A11".

I didn't find any configuration option to prevent this, is there any
way?

Thanks,
Manuel

P.D. this is Excel XP on Windows 2000 Pro

 

[Harlan Grove]

I just upgraded to XL2002 from XL97 and that's definitely
a new feature. I turned mine off through Tools > Options >
Edit tab and unchecked "Extend list formats and formulas".

Digression: how many other new & improved features have you turned off?