Change text orientation on a Pivot Table and ensure it is still changed when refreshing it

[Mokoni]

Hi,

I'm working on a big file having Power Query connections on another application.

Result is some Pivot Table having a lot of "yes/no" column with very long names in the header.

I want to changed the style of these header to always have the text vertically as displayed here :

I have an issue when refreshing : if new colmns with new labels are added, text is not vertical but horizontal and not readable...

I tried :
* select all the columns of the table and change the style
* select the complete line of the sheet and change the style
* change this in the pivot table style that I apply to my table but it seems it is not a proposed parameter :

Any idea ? Should I do that via a Macro after refreshing the table ? knowing that I already use a macro to refresh all connexions and then, pivot table, it could be added in this one but I don't know how to develop it...

 

[Kerryx]

have you tried, make sure Autofit is not selected

 

[Mokoni]

Hi @Kerryx, thanks for your answer.

I just had a look and yes it is unchecked...

As I'm using a macro to refresh all, I added a line in the macro to "reinforce" this once refreshed but it's not as clean as expected :

    Worksheets("Fields - DATA").Range("5:5").Rows(1).Orientation = 90