Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.
I am checking your excel file and trying to understand your requirement.
Are you looking for this option ?
If yes then answer is no, because this option is for the entire table, when you change it all the columns will be affected by this.
Okay, I am trying to make the format same for them. I think that can be done.
Yes ,here is the preserve format chekcbox which you can use to keep the formatting intact.
If formatting is going away when the pivot table is refreshed then you need to do below things for specific fields once :-
Put the cursor right over the headingof the desired field, then slowly move the cursor upwards. Left-click when itchanges to a downward-pointing arrow. All the data for that field will beselected. Now select Format >> Cells >> select your desired formatting >> OK.Formatting applied this way will persist when the pivot table is refreshed
I tried couple of times but I think it preserving formats. Can you specify which which column and row is not preserving it's format.