i created a spreadsheet adding 2 columns together having the sum function in
the 3rd column. when i change a number in column 1 the sum does not update.
i used this worksheet in the past and everything worked fine and all of the
sudden i don't know what i did but the function does not work.
when i try to creat the same scenerio of to the side the same thing happens.
please help what am i missing.

go to tools - options and calcualtion to set the calculation back to
automatic
"lukiedukie" wrote in message
...
i created a spreadsheet adding 2 columns together having the sum function
in
the 3rd column. when i change a number in column 1 the sum does not
update.
i used this worksheet in the past and everything worked fine and all of
the
sudden i don't know what i did but the function does not work.
when i try to creat the same scenerio of to the side the same thing
happens.
please help what am i missing.

thank you very much. it worked

"N Harkawat" wrote:

go to tools - options and calcualtion to set the calculation back to
automatic
"lukiedukie" wrote in message
...
i created a spreadsheet adding 2 columns together having the sum function
in
the 3rd column. when i change a number in column 1 the sum does not
update.
i used this worksheet in the past and everything worked fine and all of
the
sudden i don't know what i did but the function does not work.
when i try to creat the same scenerio of to the side the same thing
happens.
please help what am i missing.

20 minutes between posts shows a little impatience.

See answer to your first post.


Gord Dibben Excel MVP

On Wed, 20 Apr 2005 19:12:02 -0700, "lukiedukie"
wrote:

thank you very much. it worked

"N Harkawat" wrote:

go to tools - options and calcualtion to set the calculation back to
automatic
"lukiedukie" wrote in message
...
i created a spreadsheet adding 2 columns together having the sum function
in
the 3rd column. when i change a number in column 1 the sum does not
update.
i used this worksheet in the past and everything worked fine and all of
the
sudden i don't know what i did but the function does not work.
when i try to creat the same scenerio of to the side the same thing
happens.
please help what am i missing.