Thread: Need code assistance to update pivot table from an ADO recordset
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Need code assistance to update pivot table from an ADO records
Sorry, but I am in over my head on this.

Have you tried to add the code "ActiveSheet.PivotTables("Test
PT").PivotCache.Refresh" to your code following "Set objPivotCache.Recordset
= objRS" but before closing the database?

Tom

Reply With QuoteReply With Quote