Hi Mark,

I'm not sure what would be causing this and I can't replicate it. Have you tried different report layouts? i.e. go to the Design tab and in the Layout group there is a button for Report Layout allowing you to choose Compact, Outline or Tabular.

Mynda

Hi Mynda. 

Thanks for you support. 

I tried but that does not works. 

I attach to you the Excel file. 

I set row height (from row nr 2 to nr 7) to cm 13. Once you change the filter in pivot table in the top right corner (i.e. Vendor comm. Supplier, you will see height of rows changes.

2nd row height changes from 13cm to 23,5 cm. Other rows increase to 14cm.

I do not know how to get them fixed and stable to cm 13.

Thanks

Mark

Hello,

The file did not get uploaded. From what I notice on your video it seems your data in your drop down lists (some or all) are wider than your column width. AA7 also changes from value All to a specific article number. Check if you have line break activated on those cells.

Br,
Anders

Sorry I try to upload the file again 

Thanks 

Mark 

Apparently the cell A1 and A2 is formatted to 18 point and that is causing the issue.

Hope this helps.

Sunny

Hi Sunny,

Thank you very much for your reply. 

I didn't notice that indeed. 

Now I understand why first row resized to 23.5cm.

Do you know how to set row height to a fixed value? 

Now other problem is that if i set height to 13 cm, after any update, it always changes to 14.5 cm 

Thanks 

Mark