Quad processor & Excel 2007

[HansM]

I noticed that Excel 2007 only uses 25% of the processor (Intel Q6850). I
noticed this when processing 80K rows with a single formula each (in this
case: year() ). This is very kind, to leave me with 75% for other things,
but I would like to use 90-100% in those cases to get it done faster. Is
there a setting to activate the rest of the machine's processing capacity?

Thanks,

Hans

 

[Charles Williams]

Things like moving formulae may involve a lot of work by Excel that does not
use more than one processor:
The only part of Excel 2007 that is multiprocessor capable is the core
calculation engine. This will attempt to process separate calculation
dependency chains an separate processors.
You can see how many processors Excel thinks it is using to calculate in the
status bar message "Calculating: (2 processors) 35%"

You can control the maximum number of processing threads being used by the
calculation engine
Office Button-->Excel Options-->Advanced-->scroll down to formulas
- Check Enable multi-threaded calculation
- choose use all processors

(but this is the default setting)

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm