PDA

View Full Version : Pivottable Refresh



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:

XLGibbs
06-06-2006, 06:19 PM
ActiveWorkbook.RefreshAll

Be sure to disable background refresh on the tables/queries and to uncheck the "save data with table layout" and "enable drilldown" options...this will save both calc time and file size.