 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / February 2007Calculations
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!  SignatureRandy Street Rancho Cucamonga, CA Hi Randy Look at Tools>Options>Calculation 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. SignatureRegards Roger Govier > Hello...I am using Office 2003 Pro SP2 on Win XP Pro...Things are > looking and [quoted text clipped - 12 lines] > appreciated. > I thank you in advance for your time! 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? SignatureRandy Street Rancho Cucamonga, CA > Hi Randy > [quoted text clipped - 21 lines] > > appreciated. > > I thank you in advance for your time! Hi Randy Are there any macros running? Maybe there is one that switches Automatic to manual What happens if you press F9? SignatureRegards Roger Govier > Thank you Roger for your response....I have checked this option > already. It [quoted text clipped - 36 lines] >> > appreciated. >> > I thank you in advance for your time! 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! SignatureRandy Street Rancho Cucamonga, CA > Hi Randy > [quoted text clipped - 42 lines] > >> > appreciated. > >> > I thank you in advance for your time! 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 >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! 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.... SignatureRandy Street Rancho Cucamonga, CA > Are you sure you are saving the workbook with calculation set to automatic? > [quoted text clipped - 8 lines] > >have been working with Excel and Office for many years and am pretty > >efficient with Excel...This one is stumping me though! Hi Randy, Look at this checklist: http://xldynamic.com/source/xld.xlFAQ0024.html SignatureKind regards, Niek Otten Microsoft MVP - Excel | 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 [quoted text clipped - 13 lines] | > >have been working with Excel and Office for many years and am pretty | > >efficient with Excel...This one is stumping me though! 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! SignatureRandy Street Rancho Cucamonga, CA > Hi Randy, > [quoted text clipped - 19 lines] > | > >have been working with Excel and Office for many years and am pretty > | > >efficient with Excel...This one is stumping me though! Randy If all is well when you open Excel in Safe Mode then when not in safe mode, something is opening with Excel that turns off the calculation. You have unchecked all add-ins? You have cleared all from your XLSTART folder? Note: there can be more than one of these in your account. You have cleared the path at Tools>Options>General> "At startup, open all files in"? A format of your HD is a bit drastic, I believe. Gord >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! Hi Gord.... As far as openeing in safe mode, yes all works well in safe, but when opening in normal mode the calulations are still set to automatic....This options does not change.... All add-ins are unchecked.... XLSTART folder is empty.... "At Startup" path is empty.... Still nothing....any other ideas? I do not wish to reformat the hd but even when I un-install office completly and re-install I still get the same problem....very frustrating! Unless we/someone can come up with any other suggestions I can't think of anything else to do.... SignatureRandy Street Rancho Cucamonga, CA > Randy > [quoted text clipped - 19 lines] > >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! One more try at something........... Do a file search for *.XLB with Excel closed. This file can become corrupt at times. When that happens, strange doings can occur. When you find it(them......could be more than one) rename to *.OLD or similar. Re-start Excel and it will build a new one which is Excel's basic default settings for Menus and Toolbars. Gord >Hi Gord.... >As far as openeing in safe mode, yes all works well in safe, but when [quoted text clipped - 13 lines] >we/someone can come up with any other suggestions I can't think of anything >else to do.... Hi Gord....sorry for the delay...thanks for the last tip...that did the trick! I reeeeeaaaalllly appreciate your help with this! You are a rockstar! SignatureRandy Street Rancho Cucamonga, CA > One more try at something........... > [quoted text clipped - 28 lines] > >we/someone can come up with any other suggestions I can't think of anything > >else to do.... Thanks for the feedback. Happy to help. Gord >Hi Gord....sorry for the delay...thanks for the last tip...that did the >trick! I reeeeeaaaalllly appreciate your help with this! You are a rockstar! I have even tried uninstalling and re-installing and same thing keeps happening.... SignatureRandy Street Rancho Cucamonga, CA > Hi Randy > [quoted text clipped - 42 lines] > >> > appreciated. > >> > I thank you in advance for your time! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.