Problem workbook closed by a 3rd party error

Help
1

Scenario: I try to write on an excel sheet

Steps to reproduce: Excel application scope + write cell

Current Behavior:

The treatment has been interrupted by System.Exception: Workbook was closed by a 3rd party, while the Excel Application Scope was running.
at UiPath.Excel.Activities.ExcelApplicationScope.OnFaulted(NativeActivityFaultContext faultContext, Exception exception, ActivityInstance source)
at System.Activities.Runtime.FaultCallbackWrapper.Invoke(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.FaultWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Expected Behavior: The UiPath robot opens and updates the file

Studio/Robot/Orchestrator Version: 2017

OS Version: Win 7

Others if Relevant: (workflow, logs, .net version, service pack, etc): Nobody is connected on this machine and the robot worked till today, so nobody can close the Excel application

1 Like
2

Excel application scope will close the Excel once it is complete. If it is already closed, it will throw error. So give Continue on error property as true or give Excel application scope inside try catch.

1 Like
3

I too faced this issue, Later i resolved .
This error occurs while comparing two excels, Example: Excel A and Excel B
while performing certain operation error occurs as problem workbook closed by a 3rd party error. This is happening because of object similarity in both excel. It can be resolved by clicking on sheet name (Selector will be different for Excel A sheet 1 and Excel B sheet1). Using click command in sheets later perform the action.

Error could be resolved,

Thanks,
Kaamesh A