Thread: Calculations
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.setup
Randy Randy is offline
external usenet poster
 
Posts: 213
Default 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