I have a Pivot Table sheet and I’m using the “Filter Pivot Table” activity to filter a selected value. The activity works, but the filter value name is not visible in the Excel Pivot Table.
Alternatively, we use the click activity-clicking the filter icon and then clicking OK—and then the filter name is displayed.
Below, I have mentioned how the bot provides the output and how I want it to be.
Can you try to invoke vba activity n use below code
Sub RefreshPivotTable()
Dim pt As PivotTable
For Each pt In ActiveSheet.PivotTables
pt.PivotCache.Refresh
pt.RefreshTable
Next pt
End Sub
Thanks @vhvinodsai
I created and tested my own VBA code, and it worked successfully. However, the issue I’m referring to is related to the activity involving filtering the Pivot Table. Despite my efforts, the filtering functionality within the Pivot Table is not behaving as expected.
My issue is that the Pivot Table filter does not display the selected filter value. The activity works correctly, but in the Excel output, the filter field always shows “ALL” instead of the selected value. Please refer to the highlighted field in both Excel files above.