I don't think any patch will help this. IMHO I think that the VBA engine is just too bloated; new objects, properties and methods added to the libraries over all the previous versions has resulted in a rather cumbersome mass (if that makes any sense?)
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
I probably would tend to believe you if the differences would not have been that large, but from Excel 2003 to 2007 to 2010 this was always really fast... I thought.
However I just tried it in a VM running WinXP (no network connections) with Office 2007 and I get 5.2 seconds... that's hardly slower than my Excel2013 (but it could be the VM of course)
4.7 seconds in Office 2016 (32 bit); running in Win10 64-bit... Regretfully this data point is worthless as I'm running on a new (much faster) PC now...
So then we can safely advise others with slow code to upgrade to the latest version of the application and latest hardware to improve performance... (I'd say that is great advice!!!)
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.