Column label format after pivot refresh

[Robby Meersman]

After pivot refresh, several individual cells of column labels are rotating again from vertical to horizontal.

How can I fix this format?

15-01-2014 8-47-31.png

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Robby Meersman]

Sample.xlsxSample.xlsx

[Robby Meersman]

Nobody who can help to solve this issue?

[:) Sixthsense :)]

I tested it now and nothing changing for me and it's staying as it is

May be try to set the Formatting for the Field in Pivot Field List and check

[Robby Meersman]

I can't send the real excel file because the data is confidential, but it's weird it's still not working if you are updating your pivot table with new different data (so column are changing and increasing) then the column headers are changing

[Izandol]

It does not change for me either, but perhaps you may use code?

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
   Target.ColumnFields(1).DataRange.Orientation = -4171
End Sub

If you will add this to the worksheet (right-click its tab and choose View Code) then it will be run when the pivot table is refreshed.