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.
I lose the dark blue format as it turns to light blue. I have attached a screenshot. I can provide the file if need be.
Thanks,
Ken Mc
Hi Ken,
Here are some information that will clarify the problem:
Thanks Catalin. Neither worked for me. I will keep trying though.
Hi Kenneth,
You need to create a custom PivotTable style for the header rows. Choose a style that's close to what you want, then right-click > duplicate. Then edit the new style to suit your needs.
Mynda
Thank you Mynda!
