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
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.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Posting Permissions
Reply With Quote