Excel application scope - prompt in excel

Off-Topic Discussions
1

I have written a workflow to read content of an excel file, when the file is opened by UIPath, the excel application is raising a prompt (refer the screenshot) “The workbook contains links to other data sources…etc etc” and unless you click on Update or Dont update, the workflow doesn’t continue.

The autosave & visible flags are unchecked, but still I get this prompt, due to which it can’t be unattended. What is the reason & solution ?

image1
image1894×198 29.1 KB
image2

2

@skini76, Use Element Exists to check if that prompt exists. Then click on update/ dont update as you wish. If doesn’t exists proceed with your flow.

Regards,
Dominic :slight_smile:

3

Thanks, but the prompt is displayed outside the browser window…so the suggested solution doesn’t work. More than that, why this prompt is appearing & what should be done so that it doesn’t appear. it is not feasible to put the check for this prompt, where 100’s of excel files are opened & closed.

4

Hello there,
I don’t think that’s matter as Dominic mentioned making use of element/image exist should fix this.

This appears as excel is connected to other data source where the pull operation takes place in background which reflect the data in excel.
In case you don’t want this message to popup ! Here is the way to do this.

1 Like
5

Problem is solved after changing the settings in excel, thanks

1 Like
6

There are two solutions to this common issue :

  1. You can use “Read Range” of Workbook instead of using Excel’s “Read Range” Activity. Since Workbook read range activity reads excel content without opening it, this prompt is not encountered.

  2. If you still need to use Excel’s “Read range” activity , you can use “Parallel” activity. In one branch of Parallel , you need to put excel application scope and in another branch you need to place “Element Exist” activity to check the existence of window and do the action accordingly.

Thanks

1 Like
7

what settings do you change in excel? Thanks

8

You have to go to the Data Tab of Excel.

If you have active connections to other workbooks the option to edit links is active. In the appearing popup you have a button in the lower left croner, how the promt at startup should be handled, and there you can chose to get no warnings.

Or the simpelst way is to delete the connection to other files (of course only if you don’t need it).