ExcelBanter - How do I change source data range for an existing Pivot Table?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I change source data range for an existing Pivot Table? (https://www.excelbanter.com/excel-programming/423212-how-do-i-change-source-data-range-existing-pivot-table.html)

Paolo Sardi

How do I change source data range for an existing Pivot Table?

Hi,

I'm trying to change, through Excel VBA code, the source data range for an
existing Pivot Table.

Is there a way to set a new data source range for an existing Pivot Table?

Thank you.

All times are GMT +1. The time now is 10:19 AM.