Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My excel 2003 sheets are not automatically calculating formulas any more. I'm
not sure what happened. For example: if I add: 200 200 200 600 And change one of the 200 to 300 the sum does not automatically calculate (it will stay as 600). I can't drag formulas either. The actual number rather than the formula is copied. Thanks for any help - I am going nuts with this! Daria I can't drag a formula |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Toolsoptionscalculation and set it to automatic
-- Regards, Peo Sjoblom "Daria" wrote in message ... My excel 2003 sheets are not automatically calculating formulas any more. I'm not sure what happened. For example: if I add: 200 200 200 600 And change one of the 200 to 300 the sum does not automatically calculate (it will stay as 600). I can't drag formulas either. The actual number rather than the formula is copied. Thanks for any help - I am going nuts with this! Daria I can't drag a formula |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you Peo! You have saved me so much time as well as my sanity.
"Peo Sjoblom" wrote: Toolsoptionscalculation and set it to automatic -- Regards, Peo Sjoblom "Daria" wrote in message ... My excel 2003 sheets are not automatically calculating formulas any more. I'm not sure what happened. For example: if I add: 200 200 200 600 And change one of the 200 to 300 the sum does not automatically calculate (it will stay as 600). I can't drag formulas either. The actual number rather than the formula is copied. Thanks for any help - I am going nuts with this! Daria I can't drag a formula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Memory Issues | Excel Discussion (Misc queries) | |||
How do i increase excel working memory in office 2003 | Excel Discussion (Misc queries) | |||
Is it possible to Shell and remove Excel from memory? | Excel Discussion (Misc queries) | |||
Memory Leak in Excel | Excel Discussion (Misc queries) | |||
no enough memory to run excel viewer | Excel Discussion (Misc queries) |