View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nc
 
Posts: n/a
Default ActiveWorkbook.RefreshAll

Does the following

ActiveWorkbook.RefreshAll

refresh all pivot table as well as recalculate the workbook?

If yes, is there any way I can refresh only the pivottables in the workbook?