topic RE: Open excel was rejected in Product Forum

Open excel was rejected

EricLi — Wed, 18 Oct 2023 07:34:00 GMT

Robot open an excel was rejected. System provide message: Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED))

After check, it is because one of the worksheets include a pivot table. If delete this worksheet, robot works. But that is not I want; How can I open this kind of excel.

------------------------------
Eric Li
Operation Analysis
AIG
Asia/Hong_Kong
------------------------------

RE: Open excel was rejected

steven.boggs — Wed, 18 Oct 2023 20:42:00 GMT

Hi Eric,

Unfortunately, the 'RPC_E_CALL_REJECTED' error is generated by Excel and passed through to Blue Prism, so there's not really much from a Blue Prism Product perspective we could recommend to resolve this. This Knowledge Base article contains some external links for troubleshooting which may help with this though.

------------------------------
Steve Boggs
Senior Product Support Engineer
Blue Prism
Austin, TX
------------------------------

RE: Open excel was rejected

harish.mogulluri — Wed, 18 Oct 2023 23:45:00 GMT

Hi Eric,

Check below threads and verify whether it will help you to resolve the issue.

https://support.microsoft.com/en-us/topic/you-receive-an-error-message-or-the-program-stops-responding-in-accounting-professional-or-in-accounting-express-fbfad9f7-d574-598d-54c6-5beef60f0984

https://learn.microsoft.com/en-us/previous-versions/troubleshoot/winautomation/support-tips/excel-automation/failed-to-write-into-excel-call-was-rejected-by-callee

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------

RE: Open excel was rejected

LeonardoSQueiroz — Thu, 19 Oct 2023 01:06:00 GMT

Hello Eric,

Try including a wait stage before the action you are using, when i am get this error it helped me.

Regards,

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------

RE: Open excel was rejected

Anastasiya__Ilgova — Wed, 01 Nov 2023 12:03:00 GMT

Hey guys, we are having currently BP version 6.10.5 and having the same problem when using "Open Workbook" action after creating an instance for Excel file. Either we get Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED) or sometimes even The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) and we have solved it by removing Activate() action from the code that is behind the Open Workbook code stage:

So, actually remove activation of the Excel window from the code stage and it works perfectly for us WITHOUT sleeps and retries as were suggested above:

Example 1:

name = ExecWithTimeout(Timeout, "Open Workbook",
Function()
Dim instance = GetInstance(handle)
Dim workbooks As object = GetProperty(instance, "Workbooks")
Dim wb As Object = Invoke(workbooks, "Open", filename)
~~Invoke(wb, "Activate")~~
Return wb.Name
End Function)

Example 2:

Dim app as Object = GetInstance(handle)
app.DisplayAlerts = False
Dim wb as Object = app.Workbooks.Open(filename)
name = wb.Name
~~wb.Activate()~~

Hope it helps 😉

------------------------------
Anastasiya Ilgova
Lead Automation Developer
Automation COE
Europe/Prague
------------------------------