Pivot table row height excel 2016

[siddiq1212]

Dear Friends,
May I ask how to fix pivot table row hight in excel 2016.
I have diffrent data rows in pivot table which need different height.I have uncheck preserve cell formatting on update but every time pivot is refresh this height is chnginging to default.
Please give me some solution.

[kersplash]

I think you want to check the preserve formatting box rather than uncheck it.

[kersplash]

Can you show in an image before and after refresh?

[siddiq1212]

after refresh.PNGBefore refresh.PNG

[siddiq1212]

Check or uncheck didn't work

[kersplash]

From what I can see it appears to be something to do with the wrapped text in the cells. Pivot tables can be finicky with formatting.

[siddiq1212]

Didn't get what you are saying.Can u repeat it.

[kersplash]

I think the problem is the text wrapping in some of the cells. I don't know how to help you.