I got Error in Read Range

[MD_Farhan1 (MD Farhan)]

Hi,
I doing one Excel Automation. Deleted last row in pivot table using invoke vba the read range pivot table that time i got an error below attached my both screenshot error and work flow .

Thanks

[Parvathy (PS Parvathy)]

Hi @MD_Farhan1

Try re running your process once again.

Regards

[ashokkarale]

@MD_Farhan1,

Refer this Knowledgebase for the root cause.

The Object Invoked Has Disconnected From Its Clients. Exception From HRESULT : 0x80010108(RPC_E_DISCONNECTED)

Excel Application Scope : The Object invoked has disconnected from its clients. Exception from HRESULT : 0x80010108(RPC_E_DISCONNECTED) Try to understand the process and use case Isolate the Excel file and verify whether the Excel Application Scope is present inside the scope of a loop Add the Close workbook activity in each iteration Call the garbage collectors explicitly in the code in the places where the crash was encountered and also at the end of the code Use Invoke Method activity - S…

Thanks,
Ashok

[supriya117 (Supriya Allada)]

Hi @MD_Farhan1

Remove the Excel from the task manager manually and rerun the Process

Regards

[vrdabberu (Varunraj Dabberu)]

Instead of read range activity use the read range workbook activity and place that ativity outside of the application scope. @MD_Farhan1

Regards