I am working with a customer that is using very demanding macros in Excel 2003. He has two computer systems. The first is a laptop at 1.73 Ghz with 2GB of ram (its several years old), and the second is a fairly new 3.0 Ghz desktop with 2GB of ram.
The problem is that the laptop is able to finish the exact same data in almost exactly half the time. I have checked his paging file size and they are identical. The laptop even has more processes running!
Timings using identical spreadsheets that are local to his computer(s):
Laptop 12min
Desktop 25min
I have been looking into it and have found that during the execution of the macro the laptop utilizes 100% of its CPU time, while the desktop caps out at ~50%.
Is there a way to increase the CPU utilization, or am I off base and need to look at this in a different way?
The problem is that the laptop is able to finish the exact same data in almost exactly half the time. I have checked his paging file size and they are identical. The laptop even has more processes running!
Timings using identical spreadsheets that are local to his computer(s):
Laptop 12min
Desktop 25min
I have been looking into it and have found that during the execution of the macro the laptop utilizes 100% of its CPU time, while the desktop caps out at ~50%.
Is there a way to increase the CPU utilization, or am I off base and need to look at this in a different way?