Even though a pivot table is automatically formatted when you create it, you can add your own formatting later. For example, in the pivot table shown below, I’ve added colour to the subtotal rows, and made column B narrow. However, some of that pivot table formatting might be lost if you refresh the pivot table [...]