View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Holger Pietsch Holger Pietsch is offline
external usenet poster
 
Posts: 2
Default Error:Unable to set the visible property of the PivotItem class.

I got the error
Unable to set the visible property of the PivotItem class.

when i try to set a pivotitem to visible:
Dim PF As PivotField
Dim PFI As PivotItem
For Each PF In PFs
Set PFs = ActiveSheet.PivotTables("PivotTable2").PivotFields
For Each PFI In PF.HiddenItems
PFI.Visible = True
Next PFI
Next PF

is there any solution, I have found yet no such (only at
http://www.experts-exchange.com/msof..._20275761.html
, but they wanted me to register first...)

Thanks
Holger