Pivot Tables: Keeping Formatting

[chconnol]

I understand that if you want to keep certain formatting you've made for a Pivot table, you have to turn off auto format table and keep the Preserve Formatting checked.

However I notice that if I refresh the pivot table, a lot of my present formatting vanishes. It does not completely undo the formatting, just a lot of it.

Am I missing something or is there no way to really keep all the formatting I've done?

[no dice]

I've never had luck keeping formatting.