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