Refresh Pivot Table

Hi Everyone,

I am trying to refresh the Pivot table using refresh pivot table activity. But it is not getting refreshed. I have given the sheet name and the table name of the pivot correctly. Refresh pivot table activity is not throwing any error also. How do I refresh this pivot table?


May be the below link will work for you.


Sending hotkey to refresh pivot table is working. But I wanted to use “Refresh pivot table” activity to refresh it. Actually I am trying to refresh 2 pivot table present in 1 excel. For one of the pivot table, “Refresh pivot table” activity is working and for the other it is not.
I am calculating the distinct count in the pivot table which is not getting refreshed. Is this the reason for not getting refreshed.