Hi Experts,
Currently facing a strange problem with my pivot code.
Here i'm just trying to hide the unwanted dates(items) it's working fine in my system.
When we try to run the same code in my colleague's system its not working though we are using the same Office that is 2010.
Kindly help me how to rectify it.
Problematic code.
Set pf = PT.PivotFields("Month") With pf For Each pi In pf.PivotItems If pi.Name = Item1 Then pi.Visible = True >>>Shows typemismatch Else pi.Visible = False >>>Shows typemismatch End If Next End With
Bookmarks