Excel sometimes show dialog box: This workbook contains links and robot stops processing

Learn Academy Feedback
1

Hi,

I need to create robot that opens excel workbook and make manipulations. The problem is that when Excel application scope activity starts to process and robot opens Excel file sometimes dialog box with messages appears:
Excel opening
I used different activities such as Parrallel and Element exist indicating that message mox, I also used If activity with Element exist activity and Click activity selecting “Don’t update” button, as another way I used Send hot key activities with Right and Enter activities, but it does not work.
The problem is, that sometimes when opening Excel workbook that dialog box appears and sometimes it does not appear. How can I solve it to make robot contnue processing and click “Don’t update” button if dialog box appears and move to next steps if dialog box does not appear?

Excel uipath
Excel uipath749×106 13.6 KB

2

@Apple1

Instead of using Excel Application scope, If your file is .xlsx, use Workbook Activities

Hope this helps you

Thanks

3

@Srini84
which Workbook Activities do you mean?

4

@Apple1

Check these as below

image

You can use those instead of using excel application scope activities

Hope this helps

Thanks

5

@Srini84
What should I indicate in Table name field?
Get table range

6

Have you tried disabling the alert in excel itself. There are lots of links to disable that alert in excel, save the settings, then no pop up.

7

Open your Excel----> File------->Options----------->Advanced---------->TabName(When calculating this workbook), uncheck the option. Then this will not come.

8

@Apple1

You can use Read range to get the datatable

For more reference you can check below

Thanks

9

Guys,

Making settings in excel itself will not work, because file will be stored in shared folder and will be updated from time to time. Above I was advised not to use Excel application scope and use Get table range instead, I did it and now I am struggling with Table name field

10

Hi.
Coming back to the root of your question.
Could you post your whole IF activity. The second picture you posted looks like you are using “Element Exists” within the IF activity…is that right?
What does the boolean of “Element Exists” output is telling you?

11

@Apple1

I didn’t say to use Table Range, The selection is common, so according to your requirement Use the activities covered under Workbook, I have given you the tutorial link to check how to read and how to go further

Hope this clears you

Thanks

12

I found solution by using Open application scope, but using this activity does not allow to read values from sheet to data table