How to prevent function range auto-modification ?

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

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".

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.

"Jason Morin" wrote...
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?

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.