I have the following scenario: Using a templet with an existing pivot table.
I import some data to the templet then I need to refresh the pivot table to reflect the new data and then I need to copy the data from the pivot table into a new tab (new worksheet).
I am able to :
1) Import the data
2)Change the pivot data source (to reflect new range)
but I can not copy the output of the pivot table into another tab.
It doesn't refresh the pivot
If I use
pivotable.RefreshDataOnOpeningFile = True
it works when I open the spreadsheet but I don't want to open the spreadsheet because more processing needs to be done with the output of the pivot table
How can I do this ?