Each time a cell that affects any formula in your spreadsheet is changed or manipulated, Excel recalculates the entire worksheet.
In worksheets that have a large amount of formulas, this behavior can drastically slow down your macros.
If your workbook is formula intensive, you may not want Excel to trigger a recalculation every time a cell value is altered by your macro. Calculation property to tell Excel to switch to manual calculation mode.
If your macro manipulates pivot tables that contain large data sources, you may experience poor performance when doing things like dynamically adding or moving pivot fields. Formula When recording macros, it’s not uncommon to manipulate the same object more than once.
However, if your macro is working with lots of data, the status bar will take up some resources.
It’s important to note that turning off screen updating is separate from turning off the status bar display.
You can imagine how this behavior would slow down your macro.
You can You can add another level of performance boosting by using Enable Events property to tell Excel to ignore events while your macro runs.