Recently upgraded to a newer server it has 192 GB ram 24 processors, and excel macro that used to take 4 minutes to run now takes 30-40 minutes,
old OS server OS 2008 R2 48 GB ram 6 processors
new OS server os 2012 R2 192 GB ram 24 processors.
the macro copies data from one sheet to another...