Changing "Enable multi-threaded calculation" value

  • Thread starter Thread starter dropkin
  • Start date Start date
D

dropkin

I need a way to globally change the Excel 2007 option for using all of the
processors for calculations. I have run regmon and filemon and see nothing.
Does anyone know of a GPO/ADM/Regkey that will allow me to control this? I
want to change the value from "Use all the processors on this computer" to
"Manual"
 
I don't know of a registry setting for this.

You can set it from VBA and its an application-level setting so would apply
to all workbooks.
You can control Excel 2007's multithreaded calculation from VBA using
Application.MultiThreadedCalculation.
Application.MultiThreadedCalculation.Enabled can be True or False to turn
on/off multi-threaded calculation.

Application.MultiThreadedCalculation.ThreadMode can be xlThreadModeAutomatic
or xlThreadModeManual.
if set to Manual then Application.MultiThreadedCalculation.ThreadCount can
be set to the number of threads to use.

So add the code to a workbook_Open event for your default template or to a
workbook that will open every time Excel is started or to an XLA/XLAM that
gets loaded.

regards
Charles
___________________________________
London Excel Users Conference April 1-2: places going fast ...
The Excel Calculation Site
http://www.decisionmodels.com
 
I am unfamilar with VBA, so I'm not sure hwo to do what yuo are saying.
Additionally, isn't everyone default template unique to themselves? I could
modify default_user, but that would be good for new profiles, only.
 
Back
Top