Simple,straight foward.Thanks!!!

THANK YOU!!

Thank you so much. Its working. short & sweet Solution.

Short and sweet. Exactly the information I needed for those two options

u r a true legend

Thanks!

This was helpful! Now, what if I want the cells "behind" the pivot table (the rest of the sheet) to be gray and keep it gray color. How can I keep the same color even when I expand the pivot table? Is there a way to lock the color of the sheet? Thank you very much!

Thanks .. That helped

Thank you

Thanks for the helpful tip. I tried that, but for some reasons the borders and time formatting don't stay. As I refresh it goes back to the previous formatting. Any tips will be very much appreciated.

@mshanabar

2 жыл бұрын

Were able to find any solution for this ??

@AhmedSayed-cu1tu

Жыл бұрын

did you found any solution for this as i have the same problem

my percentage column value keep on changing from 100% to 1 value after I refresh or click the + sign to the % column. How can I fix this?

Not working with excel 2021 whenever I insert borderline after refreshing it's disappeared

What if I want to maintain the height of the column that I want to work. Everytime I refresh the pivot table, the height of the row comes again with the parameter values.

its not working width changed back :(

Does not work with conditional formatting.

This patch doesn't work anymore