If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 news 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
|
|||
|
|||
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 news 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
|
|||
|
|||
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 news 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
|
|||
|
|||
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 news 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
|
|||
|
|||
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 news 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 |
#7
|
|||
|
|||
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! |
#8
|
|||
|
|||
Calculations
Hey there again....first let me thank you for taking the time on this issue.
It is very much appreciated! Anyway...Auto Calc is set to automatic when opening and closing....this is happening on every workbook I open...all calculations do not calculate and auto calc is set.... -- Randy Street Rancho Cucamonga, CA "Gord Dibben" wrote: 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! |
#9
|
|||
|
|||
Calculations
Hi Randy,
Look at this checklist: http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Randy" wrote in message ... | Hey there again....first let me thank you for taking the time on this issue. | It is very much appreciated! Anyway...Auto Calc is set to automatic when | opening and closing....this is happening on every workbook I open...all | calculations do not calculate and auto calc is set.... | -- | Randy Street | Rancho Cucamonga, CA | | | "Gord Dibben" wrote: | | 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! | | |
#10
|
|||
|
|||
Calculations
Hi Niek and thank you for your response....I have viewed the site you
provided to no avail...still not calculating. Funny thing is I can open Excel in "safe" mode and all works great. If I open normal, no calculations....go figure...well I'm just about at my wits end with this whole thing...unless anyone else has any other ideas I may just force to open in safe mode until I get a chance to format my hd and start over! -- Randy Street Rancho Cucamonga, CA "Niek Otten" wrote: Hi Randy, Look at this checklist: http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Randy" wrote in message ... | Hey there again....first let me thank you for taking the time on this issue. | It is very much appreciated! Anyway...Auto Calc is set to automatic when | opening and closing....this is happening on every workbook I open...all | calculations do not calculate and auto calc is set.... | -- | Randy Street | Rancho Cucamonga, CA | | | "Gord Dibben" wrote: | | 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! | | |
|
Thread Tools | |
Display Modes | |
|
|