I have a workbook with multiple pivot tables on a page. The rest of the page has other content. When I hit refresh on the pivot table, it is causing a loss of formatting in the pivot table itself in some ways, but also in other cells on the worksheet. Things like cell borders, shading, font size, etc. Also, the loss of formatting is inconsistant. For example:

The page title loses all formatting
Pivot Table 1 loses cell borders.
Pivot Table 2 loses cell borders and changes all shading from green to grey.
Yet changed font colors in certain fields remain totally unaffected.

Does anyone have any ideas why it could be doing this? I need to find out before I go much farther. I have completed this workbook once already and am recreating due to other bugs that developed.

Thanks