How to refresh all data connection in excel file for a background process

Help Activities
1

Hi, I have an excel file where I need to perform refresh all data connection. Currently the process is running as foreground process where I have used excel process scope and refresh Excel data connection activity. However now I need to convert it to background process, and hence I can’t use excel process scope (It is throwing error). Is there any way to refresh all data without using excel process scope. Also, I cannot change it to macro-enable file.

2

@Arpita

Welcome to the community

May I know what error is being thrown?

Ideally it ahould not be throwing any error

Cheers

3

It’s giving the following error - Failed opening the excel file, possible reasons : file is corrupt or already used by another process. Whereas when the same process is executed as foreground it’s working perfectly fine.

4

Hi @Arpita

Can you try the below way as Show Excel Window property as False

image
image900×1538 35.4 KB

image
image1324×738 108 KB

Regards,

5

Hi @lrtetala yes, this parameter is already marked as false. The process works fine when executed locally on my system after making it a background process. But when it is executed on a server (unattended robot) I’m getting the above error.