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?
|