Hi

Right click on any cell in PTPivot Table OptionsUNcheck AutoFormat
TableCHECK Preserve Formatting

--
Regards
Roger Govier

"BK523" wrote in message
...
I have created several pivot tables and used the auto formatting function.
I
would like to alter the formatting and preserve it for the next time I
refresh the data - but I cant get the new formatting to "stick". Can you
help?