topic Re: Excel errors in Product Forum

Excel errors

sobotkav — Fri, 26 Apr 2024 12:31:36 GMT

Hello, we have recently started to encounter excel errors.

The most frequent one is this:

"ERROR: Internal: Could not execute code stage because exception thrown by code stage: Can not Create Active X component"

Sometimes a message like this pops up:

These errors happen randomly in all processes and all code stages (create instance, open workbook, run macro etc...). When we try to run the process the second time it just works like nothing happened...

Does anyone know what can be done to resolve this?

Re: Excel errors

John__Carter — Mon, 29 Apr 2024 08:22:20 GMT

Are you using more than one excel object (eg the original VBO and a modified version) and could there be some conflict between them? Or is there other activity on the VM (like another user) that could be interfering?

Re: Excel errors

sobotkav — Fri, 03 May 2024 06:25:38 GMT

Hello, sorry for the late reply and thank you for your message. We are using the original VBO, we tried several versions and the newest one causes the most problems.

No other user has access to these VMs and no one else is using them when BP is running.

These errors first started to show up after some security and office updates. Is it possible that some enterprise security policy interferes?

Re: Excel errors

John__Carter — Fri, 03 May 2024 09:14:06 GMT

If the issue started after changes to your environment then it could be some MS Office setting. This knowledgebase article and this MS page may be helpful but if not, I'd recommend raising a ticket to see if the Support team can assist you.