Exporting a Pivot Table to a Different Excel

You can copy the pivoted table to a different excel by following the steps below;

1- After the pivoted excel is saved and closed, the below mentioned vba is run with the call vb script activity. The pivoted table with this vba is saved as a different excel.

Set objXLApp = CreateObject(“Excel.Application”)
objXLApp.Visible = True
Set objXLWb = objXLApp.Workbooks.Open(“C:\Test\Report.xlsx”)
Set oSheet = objXLWb.Worksheets(1)
objXLWb.SaveAs “C:\Test\Report_pivot.xlsx”, 51

Important note: It is important to put a 5 second timer after the call vb script component. (in order to be able to open and close excel after the script runs)

2- It opens with the newly created excel open component.
3- With the copy operation, source excel is selected as the newly created excel and excel name is selected as the place where you want to copy the pivot data. Range information may vary depending on which rows of the pivoted table you need.
4- You can save excel with save and close activity.