PivotItem PageField Dropdowns Disppear

  • Thread starter Thread starter GoatieEddie
  • Start date Start date
G

GoatieEddie

Hi,

An infuriating problem and I can't find any help on it! My pivot tabl
seems to have gone a bit haywire. The dropdown arrows on two of th
pagefields have disappeared. What is interesting is that if you dra
the field to higher in the order, it regains its arrow and the ne
field which took its place looses its arrow ie it is always the field
in B12 and B13 that don't have dropdowns. However, if you drop tw
pagefields into a columnfield, then all the arrows reappear!

Two questions:

1/ Does anyone know why?
2/ How do I get my dropdowns back!? (much more important!)

Thanks,

G
 
I don't know why you've lost some of the dropdown arrows, but you could
try the following macro, to see if the arrows reappear:

'=====================
Sub EnableSelection()
Dim pt As PivotTable
Dim pf As PivotField
Set pt = ActiveSheet.PivotTables(1)
For Each pf In pt.PivotFields
pf.EnableItemSelection = True
Next
End Sub
'======================
 
Back
Top