Private Sub Worksheet_Activate()
I have a single pivot table in a worksheet. I've added the above to the worksheet (as an event on activation)
I just want to know, would a full refresh of the whole worksheet (like above), refresh the pivot table as well?
Or do I have to click on pivot table and then go to 'PivotTable Tools' ribbon and click 'Refresh all'?