#1
|
|||
|
|||
Excel Macro to "Select All" in Pivot Table Field
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 |
|
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 |