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?