I had the same effect going from Mac 2011 to 2016.
Application.Screenupdating = false helps but the speed is still miserable. The screens go blank while things are calculating.
You need to follow-up with Application.Screenupdating = true when your done.
I don't know if this is available in Windows
|