View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IanJ GSK IanJ GSK is offline
external usenet poster
 
Posts: 1
Default Can Excel take advantage of multiple processors and hypherthreadin

Data is extracted from a 50M text file and presented in Excel.
Currently takes 20 minutes to run.
Macro does around 40 excel ops per data item, appox 400K data items.

We don't have the resource to fix macro so looking for a 'quick' win and was
wondering if it was worth investing in more hardware.

Can Excel take advantage of multiple processors and hypherthreading?