Hello,
I am reorganizing a workbook containing 60 pivottables based on 7 pivotcaches.
I need to redefine the SourceData of these pivotcaches.
Would you know how to do that?
I have already seen that for pivottables this should be done like this:
pt.PivotTableWizard SourceType:=xlDatabase, SourceData:=srcd
However, I do not want to do this modification on a per-pivotable basis.
This is to make sure the number of pivotcaches does not increase during that process.
Keeping only a small number of pivotcaches is very useful for the performance of this workbook.
Any suggestion would be welcome.
Thanks,
Michel
I am reorganizing a workbook containing 60 pivottables based on 7 pivotcaches.
I need to redefine the SourceData of these pivotcaches.
Would you know how to do that?
I have already seen that for pivottables this should be done like this:
pt.PivotTableWizard SourceType:=xlDatabase, SourceData:=srcd
However, I do not want to do this modification on a per-pivotable basis.
This is to make sure the number of pivotcaches does not increase during that process.
Keeping only a small number of pivotcaches is very useful for the performance of this workbook.
Any suggestion would be welcome.
Thanks,
Michel