Slicer is changing row heights of my pivot table?

Question

I want to apply a slicer to my pivot table so users can filter easily, but whenever I select something, the row heights change. I have 'Autofit column widths on update' unchecked and 'Preserve cell formatting on update' is checked'.

Any ideas would be greatly appreciated!

Answer 1

I was able to figure this out by changing the font size of an empty column outside of my PivotTable to fit the row height I wanted. For example, I want my row height to be 30, so I changed an empty column's font size to 24. When I applied my slicer, row heights looked fine!