Change Data Source for Multiple Pivot Tables


W

WolfgangPD

I have multiple pivot tables in one workbook and would like to change the
data source on all of the pivot tables. Is there a way to do this all at
once instead of selecting each table? The data is contained in another Excel
workbook. Thanks!
 
Ad

Advertisements

G

galimi

You can iterate through, and change, the source using the sourcedata property
for the pivottable.

sheet1.PivotTables(1).sourcedata
 

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

Easy way to change Pivot table source files? 5
Pivot tables - Editing the data source shared by multiple pivot ta 1
Pivot tables - memory issues - please help 2
pivot table data 2
Single Filter to change all Pivot Tables in a Workbook 8
Refreshing Pivot Tables 1
Use named table in workbook as source for pivot tbl in other workb 1
Cannot Open Pivot Table Source File 0

Top