| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Calculations
Hello...I am using Office 2003 Pro SP2 on Win XP Pro...Things are looking and
running great until low-and-behold, Excel stops calculating! It won't calculate anything! I have the same setup on a second computer, right next to this one with the problem, and the second system work perfect. Any ideas as to why all of a sudden Excel would stop calculating? I have checked everything I could think of under tools & options and all looks good. Anyone heard of this happening before? Any assistance, suggestions, ideas....anything will be greatly appreciated. I thank you in advance for your time! -- Randy Street Rancho Cucamonga, CA |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Calculations
Hi Randy
Look at ToolsOptionsCalculation and ensure than the Automatic option is ticked. Excel takes this setting from the first Workbook opened in a session. If the first workbook you opened on the machine that day had its setting at Manual, it would stay in that mode until you set it otherwise. -- Regards Roger Govier "Randy" wrote in message ... Hello...I am using Office 2003 Pro SP2 on Win XP Pro...Things are looking and running great until low-and-behold, Excel stops calculating! It won't calculate anything! I have the same setup on a second computer, right next to this one with the problem, and the second system work perfect. Any ideas as to why all of a sudden Excel would stop calculating? I have checked everything I could think of under tools & options and all looks good. Anyone heard of this happening before? Any assistance, suggestions, ideas....anything will be greatly appreciated. I thank you in advance for your time! -- Randy Street Rancho Cucamonga, CA |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Calculations
Thank you Roger for your response....I have checked this option already. It
is set to Automatic. Another funny thing happened in that I was showing a colegue my problem and when I went to show him it worked. The minute he walked away I opened the same document back up again and then the calculations were not working again...errrrrrrrr....any ideas as to why it would work and then not work right after opening a doc? -- Randy Street Rancho Cucamonga, CA "Roger Govier" wrote: Hi Randy Look at ToolsOptionsCalculation and ensure than the Automatic option is ticked. Excel takes this setting from the first Workbook opened in a session. If the first workbook you opened on the machine that day had its setting at Manual, it would stay in that mode until you set it otherwise. -- Regards Roger Govier "Randy" wrote in message ... Hello...I am using Office 2003 Pro SP2 on Win XP Pro...Things are looking and running great until low-and-behold, Excel stops calculating! It won't calculate anything! I have the same setup on a second computer, right next to this one with the problem, and the second system work perfect. Any ideas as to why all of a sudden Excel would stop calculating? I have checked everything I could think of under tools & options and all looks good. Anyone heard of this happening before? Any assistance, suggestions, ideas....anything will be greatly appreciated. I thank you in advance for your time! -- Randy Street Rancho Cucamonga, CA |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Calculations
Hi Randy
Are there any macros running? Maybe there is one that switches Automatic to manual What happens if you press F9? -- Regards Roger Govier "Randy" wrote in message ... Thank you Roger for your response....I have checked this option already. It is set to Automatic. Another funny thing happened in that I was showing a colegue my problem and when I went to show him it worked. The minute he walked away I opened the same document back up again and then the calculations were not working again...errrrrrrrr....any ideas as to why it would work and then not work right after opening a doc? -- Randy Street Rancho Cucamonga, CA "Roger Govier" wrote: Hi Randy Look at ToolsOptionsCalculation and ensure than the Automatic option is ticked. Excel takes this setting from the first Workbook opened in a session. If the first workbook you opened on the machine that day had its setting at Manual, it would stay in that mode until you set it otherwise. -- Regards Roger Govier "Randy" wrote in message ... Hello...I am using Office 2003 Pro SP2 on Win XP Pro...Things are looking and running great until low-and-behold, Excel stops calculating! It won't calculate anything! I have the same setup on a second computer, right next to this one with the problem, and the second system work perfect. Any ideas as to why all of a sudden Excel would stop calculating? I have checked everything I could think of under tools & options and all looks good. Anyone heard of this happening before? Any assistance, suggestions, ideas....anything will be greatly appreciated. I thank you in advance for your time! -- Randy Street Rancho Cucamonga, CA |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Calculations
No sir....no macros running and nothing seems to happen when I press
F9....This is a tricky one huh!! Very strange! I am somewhat embarrassed as I have been working with Excel and Office for many years and am pretty efficient with Excel...This one is stumping me though! -- Randy Street Rancho Cucamonga, CA "Roger Govier" wrote: Hi Randy Are there any macros running? Maybe there is one that switches Automatic to manual What happens if you press F9? -- Regards Roger Govier "Randy" wrote in message ... Thank you Roger for your response....I have checked this option already. It is set to Automatic. Another funny thing happened in that I was showing a colegue my problem and when I went to show him it worked. The minute he walked away I opened the same document back up again and then the calculations were not working again...errrrrrrrr....any ideas as to why it would work and then not work right after opening a doc? -- Randy Street Rancho Cucamonga, CA "Roger Govier" wrote: Hi Randy Look at ToolsOptionsCalculation and ensure than the Automatic option is ticked. Excel takes this setting from the first Workbook opened in a session. If the first workbook you opened on the machine that day had its setting at Manual, it would stay in that mode until you set it otherwise. -- Regards Roger Govier "Randy" wrote in message ... Hello...I am using Office 2003 Pro SP2 on Win XP Pro...Things are looking and running great until low-and-behold, Excel stops calculating! It won't calculate anything! I have the same setup on a second computer, right next to this one with the problem, and the second system work perfect. Any ideas as to why all of a sudden Excel would stop calculating? I have checked everything I could think of under tools & options and all looks good. Anyone heard of this happening before? Any assistance, suggestions, ideas....anything will be greatly appreciated. I thank you in advance for your time! -- Randy Street Rancho Cucamonga, CA |
|
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Calculations
Are you sure you are saving the workbook with calculation set to automatic?
Do so then close the workbook and re-open. What's the calc status? Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 14:48:01 -0800, Randy wrote: No sir....no macros running and nothing seems to happen when I press F9....This is a tricky one huh!! Very strange! I am somewhat embarrassed as I have been working with Excel and Office for many years and am pretty efficient with Excel...This one is stumping me though! |
|
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Calculations
I have even tried uninstalling and re-installing and same thing keeps
happening.... -- Randy Street Rancho Cucamonga, CA "Roger Govier" wrote: Hi Randy Are there any macros running? Maybe there is one that switches Automatic to manual What happens if you press F9? -- Regards Roger Govier "Randy" wrote in message ... Thank you Roger for your response....I have checked this option already. It is set to Automatic. Another funny thing happened in that I was showing a colegue my problem and when I went to show him it worked. The minute he walked away I opened the same document back up again and then the calculations were not working again...errrrrrrrr....any ideas as to why it would work and then not work right after opening a doc? -- Randy Street Rancho Cucamonga, CA "Roger Govier" wrote: Hi Randy Look at ToolsOptionsCalculation and ensure than the Automatic option is ticked. Excel takes this setting from the first Workbook opened in a session. If the first workbook you opened on the machine that day had its setting at Manual, it would stay in that mode until you set it otherwise. -- Regards Roger Govier "Randy" wrote in message ... Hello...I am using Office 2003 Pro SP2 on Win XP Pro...Things are looking and running great until low-and-behold, Excel stops calculating! It won't calculate anything! I have the same setup on a second computer, right next to this one with the problem, and the second system work perfect. Any ideas as to why all of a sudden Excel would stop calculating? I have checked everything I could think of under tools & options and all looks good. Anyone heard of this happening before? Any assistance, suggestions, ideas....anything will be greatly appreciated. I thank you in advance for your time! -- Randy Street Rancho Cucamonga, CA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| complex calculations | Excel Discussion (Misc queries) | |||
| Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
| looping through a set of calculations | Excel Worksheet Functions | |||
| Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
| time interval calculations in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
