Pivot Table does not preserve formatting on refresh

[kwesmc]

When I refresh my pivot table, I lose some of the formatting. I've tried several fixes including "Preserve cell formatting on update". It is probably something stupid I'm missing, but I've run out of things to try.
Can someone please help with this issue. I can provide file if needed.
Thanks,
Ken Mc

 

[GlennUK]

What formatting do you lose?

 

[kwesmc]

What formatting do you lose?

Thanks for replying Glenn. See the light blue. That is the part I lose on refreshing.

 

[GlennUK]

Wow, bizarre. Sorry, am out of ideas too.

 

[kwesmc]

Wow, bizarre. Sorry, am out of ideas too.

Yes it is Glenn. By the way, love your salutation!!

 

[lafoug]

Hi. Did you ever figure out the issue? I have the same problem and it's maddening. I have my format perfect and every time I refresh I lost some, but not all of the formatting. I'll lose data centering and some boarders. UGH!!!!

 

[kwesmc]

Hi. Did you ever figure out the issue? I have the same problem and it's maddening. I have my format perfect and every time I refresh I lost some, but not all of the formatting. I'll lose data centering and some boarders. UGH!!!!

Not yet, but I'm still trying to figure it out. If I do, I will let you know. And yes, very frustrating!!
Thanks.

 

[lafoug]

I saw somewhere someone said that it pulls new data each time to refresh (duh) but I dont know why that would mess up cell highlights, bolds, or boarders.