Pivot table refresh causing loss of formatting on worksheet

[Calieth]

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

[teylyn]

Hello Calieth,

loss of formatting after Pivot Table refresh is a known issue and very annoying. The recommended workaround is:

Switch on the macro recorder
Format the Pivot table or Pivot chart to your liking
Stop the macro recorder

Run the macro after each pivot refresh.