UiPath not refreshing data connections

Help Robot
, ,
1

Hello,

I want to share this issue and hoping somebody has seen something similar.

Context:
We have some legacy processes that depend on refreshing OLEDB connections in excel. Recently, we have noticed these connections are not refreshed when the file is opened by uipath even when they’re refreshed if the file is opened manually.

Tracking the issue down to the event viewer we came across with this error with no further details:

UiPath.Executor 21.10.5.0 Failed to refresh the workbook UI

has anybody seen this? or know why this happens?

Notes:
I already have a workaround but want to identify the source of it because it involves re-engineering quite a few stable automations.

When I say legacy, it means they are using Excel Application Scope (versions of excel activities may differ by each artifact depending on how old they are)