Dual Processors and Macro Speed

[johnkiddier]

Hi,

I've just discovered this forum and I'm hoping that someone can hel
me!

I'm running a rather sizeable macro which generates a lot o
calculations.

I've already turned off screenupdating and optimised my code but it wa
still taking many hours to run.

I turned to new hardware to solve my problems........

I'm now running the macro on a dual 3.2ghz Xeon processor machine wit
4gb of RAM and XP professional.

It's about 20% quicker than my last machine which had a single pentiu
4 processor and 1 gb ram, but not the 200% quicker I had been promise
by our IT dept

Task manager shows that it's only using one processor, one is maxed ou
while the other is largely idle.

Is it possible to spread the load over both processors?

Alternatively, does anyone know is MS Access is able to run over dua
processors as I could tranfer my calculations over to that i
absolutely necessary......


Any help or advice would be greatfully received.

Cheers

John

 

[Jim Rech]

This brief article says that Excel is not multiprocessor aware:

http://support.microsoft.com/default.aspx?scid=kb;en-us;265361

--
Jim Rech
Excel MVP
|
| Hi,
|
| I've just discovered this forum and I'm hoping that someone can help
| me!
|
| I'm running a rather sizeable macro which generates a lot of
| calculations.
|
| I've already turned off screenupdating and optimised my code but it was
| still taking many hours to run.
|
| I turned to new hardware to solve my problems........
|
| I'm now running the macro on a dual 3.2ghz Xeon processor machine with
| 4gb of RAM and XP professional.
|
| It's about 20% quicker than my last machine which had a single pentium
| 4 processor and 1 gb ram, but not the 200% quicker I had been promised
| by our IT dept
|
| Task manager shows that it's only using one processor, one is maxed out
| while the other is largely idle.
|
| Is it possible to spread the load over both processors?
|
| Alternatively, does anyone know is MS Access is able to run over dual
| processors as I could tranfer my calculations over to that if
| absolutely necessary......
|
|
| Any help or advice would be greatfully received.
|
| Cheers
|
| John.
|
|
| --
| johnkiddier
| ------------------------------------------------------------------------
| johnkiddier's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=16626
| View this thread: http://www.excelforum.com/showthread.php?threadid=314942
|

 

[Guest]

Hi
AFAIK Excel is not able to nrun on more processors or use the second one for
its macros