Excel Multi-threading
 

I currently have 300MB Excel 2003 file that uses macros to compare various
worksheets with one another. Because of the amount of data, the process
takes several hours to complete. When monitoring the performance, the CPU is
showing 100% utilization. Since this is not actually performing any
calculations, would moving to Excel 2007, with it's multi-threading
capabilites, offer any benefit on a dual core system? Everything that I have
read regarding Excel 2007, indicates that it has a multi-threading
calculation engine, but I am not sure that this will improve a compare only
process.

Thanks,
Randy

Excel Multi-threading
 

See this white paper for everything you want to know about XL 2007
performance: http://msdn2.microsoft.com/en-us/library/aa730921.aspx

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Randy L" wrote:

I currently have 300MB Excel 2003 file that uses macros to compare various
worksheets with one another. Because of the amount of data, the process
takes several hours to complete. When monitoring the performance, the CPU is
showing 100% utilization. Since this is not actually performing any
calculations, would moving to Excel 2007, with it's multi-threading
capabilites, offer any benefit on a dual core system? Everything that I have
read regarding Excel 2007, indicates that it has a multi-threading
calculation engine, but I am not sure that this will improve a compare only
process.

Thanks,
Randy

Excel Multi-threading
 

Thanks Dave. That is what I was looking for.

Randy

"Dave F" wrote:

See this white paper for everything you want to know about XL 2007
performance: http://msdn2.microsoft.com/en-us/library/aa730921.aspx

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Randy L" wrote:

I currently have 300MB Excel 2003 file that uses macros to compare various
worksheets with one another. Because of the amount of data, the process
takes several hours to complete. When monitoring the performance, the CPU is
showing 100% utilization. Since this is not actually performing any
calculations, would moving to Excel 2007, with it's multi-threading
capabilites, offer any benefit on a dual core system? Everything that I have
read regarding Excel 2007, indicates that it has a multi-threading
calculation engine, but I am not sure that this will improve a compare only
process.

Thanks,
Randy