Having created a decoupled Pivot Chart, i.e. one which was not created from an existing Pivot Table, I would like to change the name of the underlying Pivot Table associated with that Pivot Chart.
Via the Excel ribbon, Pivot Chart Analyze/Options will allow me to change the name of the Pivot Chart, though not the underlying Pivot Table.
If I record a macro and refresh the Pivot Chart, I get:
ActiveSheet.PivotTables("PivotChartTable1").PivotCache.Refresh
though I cannot find a way to programmatically amend 'PivotChartTable1' to some other string.