preserving the cell font format when pivot is refreshed

[olybobo]

Hello Experts;

When I open my pivot and refresh it. All the font cell format gets lost. Is there anyway to preserve it. I have tried a lot of approach and nothing is working.

Please help

[jeffreybrown]

Maybe a quick google search will get you on your way...

Three Tips for Making your Pivot Table Formatting Stick

[olybobo]

none of those tips worked

[olybobo]

hi...any updates in regards to this

[jeffreybrown]

I don't know what else to say. I have used the method posted and it works to preserve the format. Maybe somebody else know of something I'm missing.

[olybobo]

I think this is a bug in excel..you can only format rows and you can not have multiple formats for multiple cell in a single row for pivots