why doesnt formatting on a pivot stay after refreshing?
 

I have the preserve formatting box checked and after chaging the colors or
borders in a pivot table, I refresh and it goes back to the way it was. Why
is it doing that? Other older versions of Excel stayed after refresh. Can
someone please help me?