Error in Excel Process Scope - 'Excel Appears to Be Busy' and 'Failed Setting the Current Sheet

Feedback Assistant
,
1

I am encountering an issue in UiPath where the Excel process opens and then immediately closes when running automation. The error occurs during the “Excel Process Scope” activity, specifically on the “Clear Sheet” action, displaying the message:
“Excel appears to be busy, Please check that you are not editing a value and no dialog windows are open.”

Additional details:

  • When switching to “Excel Application Scope,” the error reads:
    “Failed setting the current sheet to ‘sheet1’ in workbook. Original error message: 0x800AC472.”

Steps I have already attempted:

  1. Restarted the VM.
  2. Used the “Kill Excel” activity before the process.
  3. Enabled the “Force Kill” option on the Excel Process Scope.
  4. Added delays before the activities.
  5. Repaired the Robot using the installation file (version 24.10.1).
  6. Ensured Excel 2016 is the same version on both development PCs and Robot environment.
  7. Confirmed there are no background instances of Excel running.

Please note that the process is working fine in the studio.

Despite these efforts, the issue persists. Any guidance on resolving this would be greatly appreciated.

3

@Meraz_Faid,

Have you tried this solution?

4

@Meraz_Faid

Two things here

  1. Is the excel getting stoted locally in some network folder or shared drive or a one drive? If so move to local folder
  2. Check the excel settings more commands → trust cneter settings and then disable the auto update feature

Cheers