fpskidmark
Board Regular
- Joined
- Sep 11, 2009
- Messages
- 139
Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
I'm getting this error msg "Unable to set the Visible Property of the PivotItem Class" on this code <o></o>
<o></o>
<o></o>
All the PivotItems do appear when I check it using the " MsgBox/ On Error Resume Next" function, but the pivot items are not populating on the pivot table. <o></o>
<o></o>
Any suggestions?<o></o>
<o></o>
Thank you,<o></o>
FP<o></o>
fficeffice" /><o></o><o
></o>I'm getting this error msg "Unable to set the Visible Property of the PivotItem Class" on this code <o
></o>
PHP:
With Sheets("TREND").PivotTables("Felix").PivotFields("MD")
For Each pvtitem In .PivotItems
pvtitem.Visible = True
'test
MsgBox (pvtitem)
Next pvtitem
End With<o
></o>All the PivotItems do appear when I check it using the " MsgBox/ On Error Resume Next" function, but the pivot items are not populating on the pivot table. <o
></o><o
></o>Any suggestions?<o
></o><o
></o>Thank you,<o
></o>FP<o
></o>
