function does not work properly
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. |
All times are GMT +1. The time now is 01:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com