View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark J Mark J is offline
external usenet poster
 
Posts: 24
Default How to update datasources of a pivot table ?

ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh