topic Error in Open Workbook "Open Workbook took more than 30 secs." BP Version 6.1 in Product Forum

Error in Open Workbook "Open Workbook took more than 30 secs." BP Version 6.1

AnkurSharma — Thu, 15 Mar 2018 22:12:00 GMT

Hi Everyone, I have a process which tries to open a workbook which basically an Excel Macro file (.xlsm) and take some time to open due to it size. When I am trying open the workbook using MS EXCEL VBO action Open Workbook, it gives an error "Internal: Could not execute coge stage because exception thrown by code stage. Open workbook took more than 30 secs" I am not sure why BP is only waiting 30 seconds and timing out. Any guidance is appreciated. Thanks !

Hi Ankur,…

Marcde_Leon — Tue, 20 Mar 2018 12:07:00 GMT

Hi Ankur, You can definitely change the timeout for opening Excel. In the Excel VBO ""Open Workbook"" action, there is a data item called Timeout which is defaulted to 30. Changing that may solve your problem. Marc

Marc,…

PeterBly — Tue, 20 Mar 2018 18:12:00 GMT

Marc, I am on version 6.1. I do not have an input for Timeout on the Excel VBO action of Open Workbook. Are you on a different version? Pete

Can you go and check code…

IshanMahajan — Fri, 30 Mar 2018 10:40:00 GMT

Can you go and check code stage of your vbo, you may find the time out data item there.

I got the same Error, I…

ThaisSanches2 — Mon, 09 Apr 2018 19:15:00 GMT

I got the same Error, I haved change the time out data item, but the Errror goes on. The Error is only on XLSM files

I do not see timeout…

IshanMahajan — Tue, 10 Apr 2018 11:31:00 GMT

I do not see timeout dataitem inside my EXCEL VBO, did you add that ? if yes adding only a data item won't help, you need to use that as well inside the code stage. Have you tried to open the workbook using Start Process inside Utility - Environment VBO ? you can do that as well and attach to you workbook using MS Excel VBO.

RE: Error in Open Workbook "Open Workbook took more than 30 secs." BP Version 6.1

SwaroopM — Thu, 27 Aug 2020 19:51:00 GMT

Hello All,

I am facing the similar issue while both opening and closing workbook.
I increased the timeout from 30 sec to 1.5 min but still the issue persists. I am working with XLSM file which is of around 6-7 MB.

Any solution friends?

Thank you in advance!

Regards,
Swaroop.M

------------------------------
Swaroop M
Consultant
EY
Asia/Kolkata
------------------------------

RE: Error in Open Workbook "Open Workbook took more than 30 secs." BP Version 6.1

Lavanya.A — Mon, 11 Jul 2022 15:26:00 GMT

Hi Swaroop,

I am also facing the same issue with close instance of macro workbook.

Have you found the solution?

If yes, could you please share with us?

Thanks,
Lavanya

------------------------------
Lavanya Adulapuram
------------------------------

RE: Error in Open Workbook "Open Workbook took more than 30 secs." BP Version 6.1

ewilson — Mon, 11 Jul 2022 20:17:00 GMT

@Lavanya Adulapuram,

Are you using the latest version of the MS Excel VBO available on the DX? If not, I'd suggest upgrading to that and seeing if you still experience the issue.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Error in Open Workbook "Open Workbook took more than 30 secs." BP Version 6.1

diane.sanzone — Tue, 12 Jul 2022 12:45:00 GMT

Hi All! I've had similar issues with XLSM files and found that increasing the timeout in the code stages was sufficient. However, it could be that my file is in a different location. I move my file to the local user downloads folder first, then open, modify, save and close before moving it back to a network file share. If your file is not local to the bot workstation, can you try moving it there first and see if that alleviates some of the lag? Network traffic varies constantly so eliminating this variable might be just enough to get the files to respond in a more reasonable amount of time.

Hope this helps!

------------------------------
Diane Sanzone
------------------------------