Refresh of Pivot Table


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


In the sequence you can create following activities the pivot area
2.Send hotkey Alt + F5


Is there other ways then using the recording method?


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()
End Sub


Thank you