GetWorkbook(handle, "").ActiveSheet.PivotTables(PivotTable).RefreshTable
Text typeHello @sivagelli ,
which type of data item should the Data Item 'PivotTable' be (in the Start Stage of the Action Pivot Refresh)?
Thank you so much,
Camilla
As you have published the action 'Pivot Refresh', you should be able to use this action similar to the other actions on the Process page. You have to pass the Pivot table name as an input, you can either have a data item (text) on the process page with initial value of pivot table name from the worksheet. Or you can pass the Pivot table name in double quotes to the action 'Pivot Refresh'.One more question: )Where can i find the variable to put in the Value field of the Pivot Refresh Action in the Process?