Thread: Refresh all Pivots and delete old background data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnUK JohnUK is offline
external usenet poster
  
Posts: 173
Default Refresh all Pivots and delete old background data
Hi, I have in excess of 20 pivot tables in my workbook that needs refreshing
and all old information taken out of them on a regular basis.
I have in amongst my code: ActiveWorkbook.RefreshAll and
PivotCache.MissingItemsLimit = xlMissingItemsNone against individual pivots.
Is there a piece of code that can get rid of all old data from all pivots in
one go as with the RefreshAll?
Help greatly appreciated
John

Reply With QuoteReply With Quote