When Excel Activities Performing Check App State Activity Neither Going To Any Flow Not Able To Get The State Of The Excel

News Knowledge Base
, ,
1

Issue Description: While executing the Robot, Excel goes unresponsive. Hence it is not possible to find the next steps in Excel to validate the execution whether it failed or an error occurred.
While performing the Excel activities to get to know about the state of Excel in the particular window using the Check app state is not working as expected.

Root Cause: This issue is occurring due to the execution of the VBA Code Macros and performing large chunks of data manipulation in Excel.
  • This causes Excel slowness/ unresponsiveness in that Excel scope activity and the process is not able to get the state of the Excel.

Resolution:

  • Ensure the Check app state activity outside of the Use Excel File activity scope to avoid Excel unresponsiveness and to be able to run the Robot successfully.