Excel 2007 : # of processors acknowledged by Excel

[jmckenzie]

I have a Pentium Dual Core. Excel only shows 1 processor on my computer. Manually selecting 2 doesn't do anything. How can I fix this?

[Andy Pope]

What do using Control Panel > System. say about your processor?

[Justinetme]

Click on "ADVANCED" in Excel Options
Scroll Down to "FORMULAS"
Select "ALL PROCESSORS ON THIS COMPUTER"

Justine

[mgaworecki]

Does this work for just formulas or also VBA?

[Paul]

From what I've read on blogs and msdn, the multi-threading is used for worksheet (re-)calculations, so that when calculations can be done simultaneously they will be done more quickly over multiple processing engines. Obviously if you have one calculation dependent on the result of another, it cannot be done at the same time as the source calculation.

If your VBA includes worksheet functions or updates cells with formulas, then I would think it would be beneficial there as well. But haven't found a site saying so for sure.

Also, in the future, please start a new thread and provide reference to a previous thread as needed, per the forum rules.

Thanks.

[mgaworecki]

Thank you and sorry for not starting a new thread.