Error : Use Excel file : The Object invoked has disconnected from clients

[pravallikapaluri]

Hello Community,

I am appending all the 60 excel files data to one excel file.
When appending the data to one excel file getting the below error at random excel files.

Use Excel File: The Object Invoked has disconnected from it clients. (0x80010108 (RPC_E_DISCONNECTED))

What is this error?
Is there any method to sort this error?

The below one is the workflow, please check once.

Be help for this query @Yoichi @Anil_G @supermanPunch @Palaniyappan @ppr @postwick @ushu

Advance thank you for your help!!

[mkankatala (Mahesh Kankatala)]

Hi @pravallikapaluri

1. Check Excel: First, check if Excel is running and responsive. Make sure there are no dialog boxes or pop-ups that require user interaction in Excel, as this can cause the automation to fail.
2. Restart Excel: If Excel is running, try closing and reopening it. This can sometimes resolve issues where Excel is in a partially disconnected state.
3. Check Excel Add-ins: Ensure that all Excel add-ins are loaded and functioning correctly. Some add-ins can cause compatibility issues with UiPath automation.
4. Kill Excel Process: If Excel is not responding, you can use the “Kill Process” activity in UiPath to forcibly terminate any Excel processes that might be running in the background before starting your automation. Be cautious when using this method, as it can result in data loss if there are unsaved changes in Excel.
5. Update Excel and UiPath: Ensure that you are using the latest versions of both Excel and UiPath. Sometimes, updating these applications can resolve compatibility issues.

Hope it helps!!

[postwick (Paul)]

Don’t put your Excel scope inside the loop. This means you’re opening and closing Excel repeatedly. Put the Excel scope on the outside, with only Use Excel File on the inside of the loop.

[pravallikapaluri]

Thanks for everyone. I solved this issue with another method i.e, by using macros.