Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 21st 05, 02:54 AM
lukiedukie
 
Posts: n/a
Default 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.



  #2   Report Post  
Old April 21st 05, 03:03 AM
N Harkawat
 
Posts: n/a
Default

go to tools - options and calcualtion to set the calculation back to
automatic
"lukiedukie" wrote in message
news
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.




  #3   Report Post  
Old April 21st 05, 03:12 AM
lukiedukie
 
Posts: n/a
Default

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
news
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.





  #4   Report Post  
Old April 22nd 05, 10:23 PM
Gord Dibben
 
Posts: n/a
Default

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
news
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.








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Work Days only in a function? Mark Excel Worksheet Functions 4 March 29th 05 03:50 AM
The left function does not work when displaying times, how is thi. Nambo27 Excel Worksheet Functions 3 February 25th 05 07:46 PM
Concatenate Function will not work Chuck W Excel Discussion (Misc queries) 4 February 1st 05 12:41 AM
The number change from 1350 to 13.5 and Enter does not function properly hon123456 Excel Discussion (Misc queries) 2 January 19th 05 03:41 PM
The colors should work properly in Shared Excel Workbooks. [email protected] Excel Worksheet Functions 1 November 8th 04 11:55 PM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017