Update link popup handle in uipath

[Rutu_Yadav]

I want to handle update link popup using UiPath.

I’m downloading Excel file from SharePoint and updating some details in that file. while I’m doing this in attended mode update link popup is not appearing. But when I’m running process from Orchestrator popup is coming and bot unable to proceed further.

I want to click on update option.

[Palaniyappan (Palaniyappan P)]

Hi

you can either break the links or update the links.

If you want to disable this pop-up and prevent Excel from updating the links automatically, you can follow these steps:

1. Open the Excel file that is showing the pop-up message.
2. Click on the “Data” tab in the Excel ribbon.
3. Click on “Edit Links” in the “Connections” group.
4. In the “Edit Links” dialog box, select the link that you want to disable.
5. Click on “Break Link” to break the link to the external data source.
6. Repeat steps 4-5 for all the links that you want to disable.
7. Click on “Close” to close the “Edit Links” dialog box.

By breaking the link to the external data source, Excel will no longer update the data automatically, and you will not get the pop-up message asking you to update the links.

However, please note that by disabling the link, the data in the Excel file may become outdated and you may not have access to the latest information. So, if you need to have access to the latest data, you will need to re-establish the link to the external data source or update the data manually.

Cheers @Rutu_Yadav

[Rutu_Yadav]

So I need to do this maually?

[Palaniyappan (Palaniyappan P)]

Yeah it’s one time configuration with excel
Then we don’t need to
@Rutu_Yadav

[Rutu_Yadav]

I’m downloading this files from SharePoint and I have to run 7 years of monthly backdated files
And I’m performing some changes in Excel using execute macro(at that time popup is handled by VBA code)…after that I’m doing some work using Excel application scope at that time this popup is coming.
This files are keep changing so can’t do this manual work for each file.

No need to select any specific option ‘update’ or 'don’t update ’ any one is ok because I just want to handle this popup to update the excel

[Yoichi]

HI,

Can you try to use Parallel and InvokeWorkflowFile with isolated option as the following?

Callee workflow (Please set Update button as target)

Regards,

[supermanPunch (Arpan)]

Hi @Rutu_Yadav ,

If using the Modern Excel activities, maybe also check by Keeping the Display Alerts Property of Excel Process Scope as False and check if that is able to resolve it.