Refresh of Pivot Table


#1

May I know how do i refresh the pivot table of the excel file using uipath ? thank you. Although i can use recording to press on to the refresh button, I want to use sequence to execute the refresh button


#2

In the sequence you can create following activities

1.click the pivot area
2.Send hotkey Alt + F5


#3

Is there other ways then using the recording method?


#4

I suppose you can either click the refresh button, or press keyboard shortcuts for pivot refresh.

Another tedious method is using VBA, you need to find out how you can invoke the code to run following lines:

Private Sub Worksheet_Activate()
PivotTables(1).PivotCache.Refresh
End Sub


#5

Thank you


#6

Hello,

I see your question, and the solution than RupeshGonte gave you. I want to ask you how do you finally resolved it? I am trying the same thing, but without opening the Excel file. And all I have found is using Invoke Code. Do you know something more about that?