Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Hi there...I just attempted to update my budget on an excel file and none of
the formulas are working. It's almost as if I locked up the file from calculating. I have Excel 2003. Does anyone know where I went wrong? This has never happened before. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Thanks to Sandy Mann...your reply on another formula problem post helped me
out. For those who didn't see the other post, under tools/options/calculations...you need to change from manual to automatic. It works! "Nadia" wrote: Hi there...I just attempted to update my budget on an excel file and none of the formulas are working. It's almost as if I locked up the file from calculating. I have Excel 2003. Does anyone know where I went wrong? This has never happened before. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
I'm glad that it helped you as well. Excel takes the Automatic/Manual
setting from the first Workbook that is opened in that session, so every W/B opend after that will switch to Manual even if it had last been saved with Calculation set to Automatic. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Nadia" wrote in message ... Thanks to Sandy Mann...your reply on another formula problem post helped me out. For those who didn't see the other post, under tools/options/calculations...you need to change from manual to automatic. It works! "Nadia" wrote: Hi there...I just attempted to update my budget on an excel file and none of the formulas are working. It's almost as if I locked up the file from calculating. I have Excel 2003. Does anyone know where I went wrong? This has never happened before. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |