jmenche
06-05-2006, 08:28 AM
Howdy,
I have 9 worksheets with over 20 pivottables on them. Half of the tables have one data source; half have another. What is the fastest way to refresh the pivottables (in VBA of course)? Do I have to loop through each pivot and refresh? I am trying to cut down on calc time.
Thanks
:beerchug:
I have 9 worksheets with over 20 pivottables on them. Half of the tables have one data source; half have another. What is the fastest way to refresh the pivottables (in VBA of course)? Do I have to loop through each pivot and refresh? I am trying to cut down on calc time.
Thanks
:beerchug: