Perform refresh all activity in workbook without opening it

[ayushi_jain3 (ayushi jain)]

Perform refresh all activity in workbook without opening it.

Note: Cannot use excel application scope activities ( Therefore, cannot use “execute macros” and “send hotkey” activities)

Thankyou !

[Gokul001 (Gokul Balaji)]

Hi @ayushi_jain3

Check out the thread

Refreshing Excel Workbook with UIPath

Guys, I have found the solution. I created the vb file as usual with “Thisworkbook.refreshall” as the code in the sub. After I ran the VBA script using the bot, I was getting the error that “this will cancel a pending data refresh”, which was causing a manual intervention from me every time. Therefore, I went to query properties and disabled “Refresh Data in the Background” and the code works like a charm now. Thanks a lot for your help, everyone!

Activities - Refresh Excel Data Connections

Regards
Gokul

[Sudharsan_Ka]

HI @ayushi_jain3

You can try with the Refresh in Modern Excel Activities

To enable modern
Go to Activities tab-> Filters-> Modern

You will see the activities for refresh
Refresh Pivot table - For refreshing the particular pivot table
Refresh Excel Data Connection - For refreshing all the connections in the excel file

Steps will be like this

• Excel Process Scope
  • Use Excel File
  • Refresh Excel Data Connection - will have to Use Excel in the input property.
    or
  • Refresh Pivot Table - Will need to use like
    Excel.Sheet("SheetName").PivotTable("Pivot TableName")

Regards
Sudharsan