Thread: Refreshing all Pivot Tables in the On_Open() code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tony White Tony White is offline
external usenet poster
  
Posts: 1
Default Refreshing all Pivot Tables in the On_Open() code
Hello
I have 50 pivot tables( 1 original and 49 copies) that need to be refreshed
when I open the workbook. Is there a way to write a For Each...Next procedure
to step through all the pivot tables on a given sheet?
Thanks!

Reply With QuoteReply With Quote