![]() |
|
#1
|
|||
|
|||
|
I have the code below to "turn off" certain values of a field in a Pivot Table, but how do I accomplish this if I want to "turn on" all values in a field of a Pivot Table?
Thanks Dim pi_2 As PivotItem With ActiveSheet.PivotTables("PivotTable3").PivotFields ("Order") For Each pi_2 In .PivotItems If pi_2.Caption = "(blank)" And pi_2.Visible = True Then pi_2.Visible = False Exit For End If Next End With Dim pi_3 As PivotItem With ActiveSheet.PivotTables("PivotTable3").PivotFields ("Order") For Each pi_3 In .PivotItems If pi_3.Caption = "#N/A" And pi_3.Visible = True Then pi_3.Visible = False Exit For End If Next End With |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Error: "Changes made were lost...reconnect with server", when switching "from" field | randhurrle | Outlook | 2 | 02-25-2015 06:51 PM |
Word options "field shading" reverts to "when selected"
|
PaulBurcham | Word | 1 | 04-20-2013 11:18 AM |
| How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |
"Table of content" based on "Normal Style" behavior!!!!
|
Jamal NUMAN | Word | 4 | 07-08-2011 04:12 AM |
| Excel pivot table into an MS Word Doc "office 2007" | wmarsh3561 | Excel | 1 | 01-09-2010 08:03 PM |