Automatic Changing of Formulas

[Guest]

I'm using Excel 2003

I have values in cells A1, B1 and C1

I have a formula in cell G1: =SUM(A1:C1)

I type a value in cell D1 and Excel 2003 automatically changes the formula
in cell G1 to =SUM(A11), without any notification

How can I prevent this automatic changing of the formula in cell G1?

 

[Niek Otten]

Tools>Options>Edit tab, Uncheck Extend data range formulas and formats

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm using Excel 2003
|
| I have values in cells A1, B1 and C1
|
| I have a formula in cell G1: =SUM(A1:C1)
|
| I type a value in cell D1 and Excel 2003 automatically changes the formula
| in cell G1 to =SUM(A11), without any notification
|
| How can I prevent this automatic changing of the formula in cell G1?
|

 

[RagDyeR]

It's a setting that needs to be changed:

<Tools> <Options> <Edit> tab,
And *UNCHECK*
"Extend List Formats & Formulas".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I'm using Excel 2003

I have values in cells A1, B1 and C1

I have a formula in cell G1: =SUM(A1:C1)

I type a value in cell D1 and Excel 2003 automatically changes the formula
in cell G1 to =SUM(A11), without any notification

How can I prevent this automatic changing of the formula in cell G1?