Change Data Source for Multiple Pivot Tables

  • Thread starter Thread starter WolfgangPD
  • Start date Start date
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!
 
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 table data 2
Single Filter to change all Pivot Tables in a Workbook 8
Pivot tables - memory issues - please help 2
Refreshing Pivot Tables 1
Pivot table change data source 1
Pivot Table Data Source 1

Back
Top