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

P

Paolo Sardi

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.
 
P

paulgu

Joined
Apr 29, 2008
Messages
66
Reaction score
0
Hi Paolo,
Try:
Range("K4").Select
ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:=ActiveSheet.Range("NewDataSourceRange")
The range selected (K4 here) should be a cell within the pivot table.
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
dynamic source range change in pivot table 4
Macro to update pivot table data range 3
DYNAMIC RANGE FOR PIVOT TABLE 1
Pivot table multiple filters 2
How to identify Chart Source data as range? 3
macro creating new pivot table 2
How to refresh a pivot table that uses changing source data 1

Top