preserving the cell font format when pivot is refreshed

olybobo · #1 05-12-2016, 07:40 AM

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 · #2 05-12-2016, 09:07 AM

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

Three Tips for Making your Pivot Table Formatting Stick

olybobo · #3 05-12-2016, 09:36 AM

none of those tips worked

olybobo · #4 05-17-2016, 01:01 PM

hi...any updates in regards to this

jeffreybrown · #5 05-17-2016, 03:50 PM

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 · #6 05-18-2016, 06:24 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pivot not showing number format with commas	olybobo	Excel	1	05-05-2016 05:09 PM
Exporting a .ppt file in .pdf format preserving the animations	bolomanonbolo	PowerPoint	2	04-17-2015 04:27 AM
Novice to Pivot Table: Need help to generate a report in a predefined format	Himansu	Excel	2	10-26-2014 03:57 PM
udf value not getting refreshed , have to click on each - pls help	Deepak Kishwar	Excel	2	05-12-2014 09:21 AM
Cell font and font size	teza2k06	Excel	3	02-10-2014 11:09 PM