I have multiple pivot tables in one worksheet, however when I set the SourceData for each one of them to a range the size of the file grows drastically. What I tried is setting the SourceData on one of them to the range and then in a loop set the SourceData for each one of the other PivotTables to point to the first one, but I keep getting an error. Any ideas what I am doing wrong?
However this is giving me an error on the follolwing linePlease Login or Register to view this content.
pt.PivotTableWizard SourceType:=xlPivotTable, SourceData:="MainPivot"
Run-time error '1004':
Application-defined or object-defined error
Bookmarks