| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables
Thanks Kent. Works great
"klysell" wrote: Hi Steve, You probably already have this one answered, but I found some code on a website referenced from this DG that does the trick. It was found on the following site: http://www.contextures.com/xlPivot04.html Here it is: Sub DeleteMissingItems2002All() 'prevents unused items in non-OLAP PivotTables 'in Excel 2002 and later versions 'If unused items already exist, 'run this macro then refresh the table Dim pt As PivotTable Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets For Each pt In ws.PivotTables pt.PivotCache.MissingItemsLimit = xlMissingItemsNone pt.PivotCache.Refresh Next pt Next ws End Sub Just integrate it into your code and it works beautifully! -- Kent Lysell Financial Consultant Ottawa, Ontario W: 613.943.9098 "Steve" wrote: I have dynamic data that is summarized in Pivot Tables. Once refreshed the old data is still in the dropdowns but not actually still in the data. Is there a way to purge non-existant data from the dropdowns? Thanks Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
| Pivot tables-controlling user interaction with pivot tables | Excel Programming | |||
Threaded Mode
