A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Calculations



 
 
Thread Tools Display Modes
  #11  
Old February 9th, 2007, 06:33 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old February 9th, 2007, 09:18 PM posted to microsoft.public.excel.setup
Randy
external usenet poster
 
Posts: 398
Default 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  
Old February 9th, 2007, 11:44 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old February 15th, 2007, 01:23 AM posted to microsoft.public.excel.setup
Randy
external usenet poster
 
Posts: 398
Default 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  
Old February 15th, 2007, 05:20 AM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.