I have been suffering from "upgrading" Excel 2013 bits to Excel 2016 64 bits. There are some excel marco becoming painfully slow, says 8 -10 times slower, in Excel 2016 64 bits, compare with Excel 32 bits.
Microsoft tells me Excel 64 bits is a lot better than Excel 32 bits, in term of file size limit, memory management.... blah..blah...blah... In fact, I don't see any so called "improvement" for a product developed almost 30 years ago. People are asking for a productive tool to get their job done and go back home on time. You cannot expect every car owner knows how a car works and able to fix it.
After pulling my hair off for days, I find that there are things have to be disabled before running a sizable marco for the "best performance". The reasons behind is something actually does not matter to people life. *Though... can be easily found on Google, some of them are just ridiculous.
Application.EnableEvents = False
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.PrintCommunication = False
Application.EnableAutoComplete = False
Application.EnableLivePreview = False
Application.Cursor = xlWait 'When the mouse cursor pointed on a cell, the excel slows down
I am now going back home.
Even executing a simple macro resizing comments will result to not responding but it will execute slowly
ReplyDelete