Wednesday, February 22, 2017

Excel 2016 64 bits - Slow marco




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.

1 comment:

  1. Even executing a simple macro resizing comments will result to not responding but it will execute slowly

    ReplyDelete

Applying SMA10/20, SMA20/50 as trading signals

This is the comparison for results before and after applying SMA10/20 and SMA20/50 in the stock trader. Background Trading 3 stock ma...