| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refresh all Pivots and delete old background data
Hi John
Debra Dalgleish shows code to do this on her page at http://www.contextures.com/xlPivot04.html -- Regards Roger Govier "JohnUK" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refresh all Pivots and delete old background data
Many thanks Roger
"Roger Govier" wrote: Hi John Debra Dalgleish shows code to do this on her page at http://www.contextures.com/xlPivot04.html -- Regards Roger Govier "JohnUK" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query doesn't add/delete data in rows on refresh | Excel Discussion (Misc queries) | |||
| after external data refresh, Delete row of manual entries | Excel Discussion (Misc queries) | |||
| Background refresh not working | Excel Programming | |||
| routine to refresh all pivots in WB acroos several sheets | Excel Discussion (Misc queries) | |||
| Pivots using other pivots and dynamic query problem | Excel Programming | |||
Linear Mode
