Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Controlling Pivotitems.visible sxhwabbiemike Excel Discussion (Misc queries) 0 January 21st 09 03:09 AM
MS Office multiuser edition? OO Excel Discussion (Misc queries) 4 February 8th 08 10:45 PM
Show All PivotItems in XP pivot table tod Excel Programming 0 February 4th 04 05:07 PM
setting up excel for multiuser salam Excel Programming 2 January 7th 04 07:51 AM
Add PivotItems to PivotTable / Enabling - Disabling PivotItems Ole[_3_] Excel Programming 1 July 8th 03 03:24 PM


All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"