I'm trying to change the data source of an existing pivot table, but I get the message "a pivot table report cannot overlap another pivot table report". This is the only pivot table on the worksheet. This is my code. The error occurs on the line shown in red.

With Sheets("Analytic Table")
.PivotTables("PT-Analysis").PivotTableWizard SourceType:=xlDatabase, SourceData:= _
"'Input Table'!R1C21:R" & NumRows & "C22"

.Visible = True
.Visible = False
End With

Can anyone tell me how to reference the existing pivot table and just update its data source? TIA.