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 |
#11
|
|||
|
|||
Calculations
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 ToolsOptionsGeneral "At startup, open all files in"? A format of your HD is a bit drastic, I believe. Gord On Fri, 9 Feb 2007 08:47:00 -0800, Randy wrote: 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! |
#12
|
|||
|
|||
Calculations
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.... -- Randy Street Rancho Cucamonga, CA "Gord Dibben" wrote: 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 ToolsOptionsGeneral "At startup, open all files in"? A format of your HD is a bit drastic, I believe. Gord On Fri, 9 Feb 2007 08:47:00 -0800, Randy wrote: 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! |
#13
|
|||
|
|||
Calculations
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 On Fri, 9 Feb 2007 12:18:00 -0800, Randy wrote: 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.... |
#14
|
|||
|
|||
Calculations
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! -- Randy Street Rancho Cucamonga, CA "Gord Dibben" wrote: 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 On Fri, 9 Feb 2007 12:18:00 -0800, Randy wrote: 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.... |
#15
|
|||
|
|||
Calculations
Thanks for the feedback.
Happy to help. Gord On Wed, 14 Feb 2007 16:23:30 -0800, Randy wrote: 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! |
|
Thread Tools | |
Display Modes | |
|
|