Pivot table - data source links to new workbook

[gerald24]

Hi,

Is it possible to make my pivot table links to its data source in a new workbook?

For example:

In Examplefile.xlsm
I have "Datasource" sheet and "Pivot" sheet.
But I need to make a copy of both sheets to a new workbook.
So I click the 2 sheets and create copy to a new workbook.

Apparently, the above would end up the Pivot Table in the new workbook linking to Examplefile.xlsm's Datasource sheet.


Thank you Captain!

 

[gerald24]

Anyone know why the below returns an error (Invalid procedure or argument) when I have a slicer?

  Sub ptupdate()

    With ActiveSheet
        Sheets("Sheet1").PivotTables("Pivot").ChangePivotCache ActiveWorkbook. _
            PivotCaches.Create(SourceType:=xlDatabase, _
            SourceData:="Data")
    End With