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
Bookmarks