I have 4-5 pivot tables on a single worksheet. Every time i refresh the pivot tables the size of the table shrink or expand and a lot of headers & data are hidden and then i manually select the row and column and drag and increase/decrease the size of cell. How to manually set the size of cells and freeze it so that refreshing the pivot tables don't change the size of cells.

Regards,
Dean