Macro speeds between 365 and Excel 2021

[Justbob]

I have a macro that I record when it starts and ends. The macro can run up a few hours depending on the amount of data being analyzed. I have started to use another computer to run it so I can continue to work in excel. I have 3 computers, one with office 365, one with office 2021 and one with office 2016. There is a considerable speed difference running the same macro analyzing the same data. I would expect 2016 to be a little slower perhaps but I was surprised that 2021 was up to 8x slower that 365. Anyone know why? 2016 was at least 2x slower as 2021.

 

[Justbob]

Yeah that looks good
All down to the processor by the looks of it

Thanks for the information.