Hello all! Only today i see this tread...
My story was:
4 Years from now i got a q6600 to process a excell sheet...
I originali created this excel sheet on excel2003 and it runs some thousands of calculations, with complex interactions, and multiple macros with realtime data.
Originaly i used excel with afinity with only one core, and with priority of realtime.
When i tried export that sheet to excel 2007 the result with my quad core q6600 was way to slow... the multi thread do not really work and the sheet So my conclusion was that microsoft made an visualy apealing produt but only that, as we we really lost speed. In the excel2010 has we have the same base-coding we have the same problem!
Until today i use only the excel 2003. (Your macro file its for excel2077!)
Jonh can you try run your macro speed file with excel2003? The results may be interesting!
(If you can chose afinity with only one core and with realtime that may be better)