Disable or enable real-time screen update action

The Disable or enable real-time screen update action of the Excel advanced package enables you to disable the real-time screen update.

Settings

  • Select the Disable option to disable real-time screen update when you perform actions in a Microsoft Excel worksheet with large data sets.
  • Select the Enable option to re-enable real-time screen update for other, subsequent actions.
  • Enclose the action that has performance issues within the Disable or enable real-time screen update action.

    For example, if you are using the Run macro action to run a macro on a worksheet that has large data sets and if you are facing performance issues, use the Disable or enable real-time screen update action before the Run macro action and select the Disable option to disable real-time screen update for enhanced performance. Use the Disable or enable real-time screen update action again after the Run macro action and select the Enable option to re-enable real-time screen update for other, subsequent actions.

Important: We recommend using this action only if you face performance issues when you run actions with large data sets.