Pivot Tables in VBA
Posted by Bill on December 28, 2000 10:05 AM
I am building my first set of pivot tables in a production application in VBA. In the past, I have had a (perhaps unfounded) fear that by using Pivot Tables I would lose some measure of control.
If you've had experience using pivot tables in VBA, I would appreciate any advice about any "gotchas" that I have to watch for.
1) Creation of the pivot table takes several steps. First, there is the PivotCaches.add().CreatePivotTable, then I set some table settings, add fields, add data fields, and limit the PageField to a particular value. Is Excel re-calculating the pivot table after each command? Is there a way to turn this off until I get the whole pivot table defined in order to speed macro execution?
Thanks in advance for any advice.