I want to automate the following process with Excel:
- download an email attachment from outlook and save it in Folder A
- open Excel PQ file, which contains Power Queries, which are connected to Folder A
The Excel files queries are set on automatic refresh when opening the file.
The problem which Im facing is, when UiPath opens the Excel PQ (step 2), its not refreshing the queries. It seems that UiPath disables automatic Power Query refreshs.
Thank you for your support!