Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table show items with a value
using the code below I have two issues:
1)items with a zero $ value display 2)in the drop-down the selection boxes are not updated Thanks in advance for your help! Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem On Error Resume Next For Each pt In ActiveSheet.PivotTables For Each pf In pt.RowFields pf.AutoSort xlManual, pf.SourceName For Each pi In pf.PivotItems pi.Visible = True Next pi pf.VisibleItems = True pf.AutoSort xlDescending, pf.Value Next pf Next pt wynnyderpooh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - show items with no data | Excel Discussion (Misc queries) | |||
Show Pivot Table Items That Have No Data | Excel Discussion (Misc queries) | |||
Pivot table-show all grouped items | Excel Discussion (Misc queries) | |||
Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
Code to Show All Pivot Table Items | Excel Programming |