Pivot Table Filter Rows Resizing

[Ripley2453]

Hello,

I've been reccomended here to ask about a problem that I just can't seem to find the answer for. I've tried searching google and in-fact everywhere and I can't seem to find a way to fix my problem.

Basically I've built a pivot table, and whenever the filters are changed, or the pivot is refreshed the filter rows always seem to resize!
There's about 7 filter rows on the pivot, and when they auto-size they take up almost half the screen! I want them set at around 16 row height, and I want them to stay that size no matter what happens.

I know that you can un-tick the box in pivot table options, to stop columns auto-sizing and that's all fine and dandy. But I cannot seem to find a way to stop ROWS from resizing!
I'd like to think I'm quite advanced at Excel, I use it everyday and it's my job as a Data Analyst. However, it's frustrating me that I can't seem to find a way around this problem.

Please, someone help me!

I'm using Excel 2013.

I'm new here, and I'm not quite sure how to upload a screenshot. But hopefully my description of the problem will suffice!

Any help will be appreciated.

Cheers!

 

[Ripley2453]

I take it no one knows how to do this and I'm right in thinking it's more a program error?