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(A1:D1), without any notification

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

ToolsOptionsEdit tab, Uncheck Extend data range formulas and formats

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jecameron" wrote in message ...
| 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(A1:D1), without any notification
|
| How can I prevent this automatic changing of the formula in cell G1?
|

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!
================================================== ===

"jecameron" wrote in message
...
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(A1:D1), without any notification

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