• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Slicer Refresh

Dear All,

Can you please let me know if I click on slicer, how can the row height be retained for the pivot table.

The moment slicer is clicked, the corresponding pivot table row height is being altered.
Could you please provide a workaround for this.

Thank You and Regards,
Pavan.
 
I failed to reproduce the issue. I have created the pt in Excel 2007 and changed the row heights. Upon refresh the pt row heights remain unchanged.
 
Thank you Deepak, I am using 2016 Excel and I meant not just refresh. I have created a slicer and the moment I click on slicer, the pivot is getting refreshed with change of row heights. Hope I am clear in explaining the issue I faced.

Regards,
Pavan.
 
Back
Top