hide blank rows in Segmentation tool

Copper Contributor

Hi everyone,

 

Have got several questions:

 

1. I'm trying to hide the "Blank" rows that shows on my data segmentation tool, and don't know how.

 

Nai_edodo_1-1685407080816.png

 

 

2. Is there a way to avoid my pivot table to shrink each time I update my data?

Nai_edodo_2-1685407246498.png

I have selected the option showed in the picture, but still have the same problem, everytime I refresh

Nai_edodo_4-1685407499609.png

3. I'm trying to hide this filter icono on all my pivot table 

Nai_edodo_5-1685407788018.png

 

with this code in macro but always getting this same error:

 

Code:

Sub FiltersTD()

        Dim PT As PivotTable
        Dim Campo As PivotField
        For Each PT In ActiveWorkbook.PivotTables
               For Each Campo In PT.PivotFields
                     Campo.EnableItemSelection = False
               Next Campo
        Next PT

End Sub

 

I get the same error all the time I get "error 1004, un defined object" and the problem seems to be because of this quote "CampoTD.EnableItemSelection = True"

Nai_edodo_7-1685408418831.png

 

Nai_edodo_6-1685408381983.png

 

What can I do?

 

Thanks in advance.

1 Reply

@Nai_edodo 

Regarding 1: Avoid rows with blank cells, especially in date columns as it disturbs Excel's time and date calculation capabilities. You can't hide (en blanco) from that view if you have blanks in the column.

 

Regarding 2: You should unckeck the box that you marked yellow!

 

Regarding 3: Toggle off the 'Field Headers' button, though this will not only hide the filter button.

Riny_van_Eekelen_0-1685426813095.png