I have built a Pivot Table and am having a hard time getting it to retain my standard formatting after I refresh.
I have selected "Preserve Formatting" under Pivot Table Options.
The table is holding the formatting on the body - but not for the Subtotals.
For example:
Down the Left side I have Products, in the body I have the sum of volume.
The volume retains the formatting, but where it says "ETHANE TOTAL", it will not retain this formatting.
I appreciate any help you may have.
Bookmarks