Robot hang up due to MS Excel dialog box " This workbook contains link.."

[HILOMAP (Paul George)]

Hi All,

Good day.

Would like to seek your RPA expertise.

Background: I am consolidating the “Cover page” sheets of different files. When the Bot opens the file with linked formulas, an MS excel dialog box appears then the bot hangs up in the “Body closed and Body Executing” and also there’s no error thrown. I tried fixing it by using the following sets of activities but none of them works (or the bot does not continue doing the activities):

1. Element Exist (to catch the dialog box)

2. If and click activities (to click don’t update if dialog box appears)

3. On element appears and click activities (to catch the dialog box and click don’t update)

4. Attach window and click image activities (to activate dialog box once it appears then click don’t update)

IF Sequence within a For Each activity

MS Excel dialog box

Portion of activities where the bot hangs up

Appreciate your help on this, thanks in advance.

-paulee-

[Palaniyappan (Forum Leader)]

Hi
Kindly try once with WORKBOOK activities which has the similar activities like what we have in excel package
So search in activity panel as Workbook and under which we will be having READ RANGE and WRITE RANGE activity

Cheers @HILOMAP

[balupad14 (Balamurugan)]

Hi @HILOMAP,

Here is the activity to update the excel link s.

UiPath Go ! Edp Excel Activities

Excel functionality simplifier This package contains multiple custom activities that simplify processes in Excel. Scope - An activity specified workbook is needed and the Excel application is closed. The below activities can be executed: Copy As Picture - copy the selected cell range as an image. It performs the Copy As Picture functionality which is in the Excel workbook. SaveAs Workbook - save the excel file with a different format. Read Cell Formula - read the cell’s formula value https…

Name Space :

Design Screen :

Sample :HILOMAP.zip (17.5 KB)

Thank you
Balamurugan.S

[HILOMAP (Paul George)]

Thanks @balupad14!

so is it possible to just add it before my Copy Cover Pages_Excel Application Scope?, just to suppress the update link dialog box?

[HILOMAP (Paul George)]

Thanks much @Palaniyappan, I will try that one…

[HILOMAP (Paul George)]

Hi @balupad14

would just like to ask if edp is available in uipath packages? and if it is free?

thanks much:)

[HILOMAP (Paul George)]

thanks for sharing, but this doesn’t work, the bot still hangs up when the MS excel dialog box appears.

[HILOMAP (Paul George)]

thanks for sharing, but still it doesn’t work. the issue still persist.

[HILOMAP (Paul George)]

Hi All, is there any who has another idea to suppress the MS excel dialog “this contains link…”?

thanks in advance.

[Palaniyappan (Forum Leader)]

Let’s do one thing
Once after using Excel application scope and a read range within it use a KILL PROCESS activity with ProcessName as “EXCEL”
So that even though this message if appears the application will get closed either

Cheers @HILOMAP

[balupad14 (Balamurugan)]

Hi @HILOMAP,
You can use this out side of excel application scope.

Thank you
Balamurugan.S