View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roelof van Wyk Roelof van Wyk is offline
external usenet poster
 
Posts: 5
Default PLEASE HELP** Pivot table auto updating

You need this line in your macro.
ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh
You can record it by clicking on the Pivot tabel and refresh ! it.