Display Alerts = False End Sub Public Sub Stroboscope On() Application. Calculation = xl Calculation Automatic Application. Turned it back off for that connection and the workbook no longer flashes. By passing this method a True or a False value, you can indicate whether you want to display updating within the main Access window.The form includes a checkbox that allows you to run the test with screen updates enabled or disabled.
Since I cannot install Excel 2016 on the same PC as previous versions without causing unwanted problems I used a VM on my desktop and also ran the benchmark on my Surface Pro 3.
Display Alerts = True End Sub option back on for one of the connections and the flashing started again.
Public b Screen Updating As Boolean Public b Enable Events As Boolean Public xl Calc As Xl Calculation Public Sub Persist App Settings() b Screen Updating = Application. Namely: Furthermore, if the restore procedure is never called, due to an error or code branching, then the settings are never restored. The class exposes properties that allow you to disable certain Excel properties from being restored, and a series of constants allow you to define the default behaviour of the class. Restore End If End Sub Public Property Get Restore Calculation() As Boolean Restore Calculation = this. It's logical, for my workload, to save and restore the calculation property, but it mightn't be a property that you want to change, or want to have to turn off every time, so the constants were a way of making the class adaptable to a developer's preferred default behavior.
Gurs does not want to speed up his benchmark because that would destroy his historic speed comparisons.
But the problem is that a large portion of the time in his benchmark is taken by screen updating, and so his benchmark results vary significantly depending what part of the worksheet is actually visible on the screen, and hence how many visible cells get refreshed at each calculation.
I intend to write about the best practices in the coming weeks, but let us get back to the issue at hand.