Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel memory not working
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
|
|||
|
|||
Excel memory not working
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
|
|||
|
|||
Excel memory not working
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 | |
|
|
Similar Threads | ||||
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) |