View original (French)

Dynamic Table Row Height

Solved
Yenth29 Posted messages 13 Status Member -  
Yenth29 Posted messages 13 Status Member -

Hello,

I have a pivot table to the right of my data table. When I want to refresh the table or use a filter in a segment, all the corresponding rows in the sheet change height.

The rows of my data table (A3:J95) are set to a height of 9.5. I would like my pivot table (L13:N35) to remain at a row height of 9.5. However, after refreshing, the rows from 13 to 35 change to a height of 15. I have already checked “keep cell formatting on update”.

I made a macro to refresh and reset the rows to the correct height, but that’s not practical.

Do you have a solution? Thank you


3 answers

  1.
    Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     

    .

    Good evening.

    You should not check the "Automatic line break" tool.

    1
    1. Yenth29 Posted messages 13 Status Member
       

      Hello. In the end, the problem didn't come from there.

      It's when I insert a slicer that the rows in the pivot table automatically increase. If I resize the rows to the desired height, and then use the slicer, the height change returns.

      Attached are the slicer settings, I've tried everything without success.

      https://imgur.com/uj204PJ

      0
  2. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     

    OK! See you next time...

    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)

    1
  3. Yenth29 Posted messages 13 Status Member
     

    I must have checked it by mistake, it's working.

    Thank you very much.

    0