Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivotitems in a multiuser environment
This is just FYI: I got this problem resolved by setting all the pivotitems values to true using 'For each' statemen
and then using another 'for each' statment , set all pivotitems visible property to true except the specific item for that use login id ========================================= On Error Resume Nex With pt.PivotFields("Series" pf.AutoSort xlManual, pf.SourceNam For Each pi In pf.PivotItem pi.Visible = Tru Next p pf.AutoSort xlAscending, pf.SourceNam End Wit On Error Resume Nex With pt.PivotFields("Series" pf.AutoSort xlManual, pf.SourceNam For Each pi In pf.PivotItem pi.Visible = Fals If pi.Value = uname The pi.Visible = Tru End I Next p pf.AutoSort xlAscending, pf.SourceNam End Wit ================================================== |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controlling Pivotitems.visible | Excel Discussion (Misc queries) | |||
MS Office multiuser edition? | Excel Discussion (Misc queries) | |||
Show All PivotItems in XP pivot table | Excel Programming | |||
setting up excel for multiuser | Excel Programming | |||
Add PivotItems to PivotTable / Enabling - Disabling PivotItems | Excel Programming |