Pivot table row height resizing on data refresh (but only in certain circumstances)

[JL12016]

This is a weird one. Basically, I have a pivot table and in the interest of presentation and formatting, I have set a custom row height of 24 to all rows in the sheet. At this stage, everything is fine - when I refresh or re-filter the data, styling and row heights are retained.

However, if I add a chart or image (i.e. logo) into the sheet, whenever I refresh or re-filter the data the rows revert back to being the default height of 15.

I've gone through every logical way I can think of to work around this but to no avail. Has anyone come across this before and / or know of a solution?

Thanks!

 

[JL12016]

Apologies for the bump, but any ideas?