Calculation mode...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Question: Calculation mode appears to be a global rather than a per workbook setting, which is potentially very dangerous if you have first opened a workbook which has Manual calculation set, and then open workbook(s) that are supposed to be automatic. What were you thinking when defining it in this manner? This most definitely needs to be set on a workbook basis rather than the way it is currently done. BTW, I am using Office XP and in general it is more bug-laden than Office 97 was.
 
lol
this is probably the wrong place for your 'comments'. Most people here
are NOT from Microsoft but users as you are one.


--
Regards
Frank Kabel
Frankfurt, Germany

young said:
Question: Calculation mode appears to be a global rather than a per
Click to expand...
workbook setting, which is potentially very dangerous if you have first
opened a workbook which has Manual calculation set, and then open
workbook(s) that are supposed to be automatic. What were you thinking
when defining it in this manner? This most definitely needs to be set
on a workbook basis rather than the way it is currently done. BTW, I am
using Office XP and in general it is more bug-laden than Office 97 was.
 
Who are you actually imparting this information to??

You're certainly not telling us anything we don't know, but we are not Microsoft
employees. The folks on here give up their personal time willingly and freely
to help other folks with problems they may be having using this app, and all
efforts are on a volunteer basis only. We get a buzz out of using it and
helping others to use it, but that's it, so you're beating up on the wrong folks
here :-)
 
My apologies... I did not notice that this was a newsgroup, rather since I accessed it from Microsoft's site, thought that perhaps they read and responded to these

Regards

Chris
 
You can turn off calculation by the setting of the first workbook, another
place might be running a macro or addin that terminates before
turning calculation back on.

When I am having a problem with Calculation being set to manual
for some unknown reason, I have a macro that is invoked when
Excel starts up and it tells me if Calculation is manual and sets it
to automatic. It helps to discover as soon as possible that it has
been set to manual in order to find out why. The Auto_Open macro in
http://www.mvps.org/dmcritchie/excel/slowresp.htm#addins


young said:
Question: Calculation mode appears to be a global rather than a per workbook setting, which is potentially very dangerous if you
Click to expand...
have first opened a workbook which has Manual calculation set, and then open workbook(s) that are supposed to be automatic. What
were you thinking when defining it in this manner? This most definitely needs to be set on a workbook basis rather than the way it
is currently done. BTW, I am using Office XP and in general it is more bug-laden than Office 97 was.
 
Back
Top