Menu
Can some quicly explain the way to deselect all items in a newly created pivot table so that I can go back and select only one or two items? I tried the following:
.PivotItems("(Select All)").Visible = False
Thanks.
932
To remove all report filters, labels, values, and formatting from a PivotTable, and to start designing the layout all over again, use the Clear All command. Click the PivotTable or PivotChart. On the Analyze tab, in the Actions group, click Clear, and then click Clear All.
Deselect Specific Columns in Excel Below are the steps to so this: Select the entire sheet by clicking on the triangle at the top-left part of the sheet (or use the keyboard shortcut Control + A) Hold the Control key and select the columns that you want to remove from the selection (#5 and #9 in our example)
Select an entire report Click the PivotTable. On the Options tab, in the Actions group, click Select, and then click Entire PivotTable.
This is probably the closest you can get to what you want:
Dim i As Long
.PivotItems(1).Visible = True
For i = 2 To .PivotItems.Count
.PivotItems(i).Visible = False
Next
This will make the very first option the only selected option (assuming this is within a with that points to the pivotfield). If you know what you want before hand... modify accordingly.
174
I've found that looping through each data item takes a lot of time, what you can do if you want to filter on a single item in a pivot without looping through all items is use the following code:
ActiveSheet.PivotTables("Your Pivot Name").PivotFields("Your Field Name").ClearAllFilters
ActiveSheet.PivotTables("Your Pivot Name").PivotFields("Your Field Name").PivotFilters.Add _
Type:=xlCaptionEquals, Value1:="Your string here"
this is basically a label filter but it worked for me.
2
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
