Preserve field formatting e.g.) % when added or removing from Pivot

Hi All,

I tried searching for this but I'm not sure of the right way to phrase it so couldn't find anything suitable.

I have a pivot table with a number of fields in, some calculated. Everytime I remove them and then re-add to say restructure a table I have to define all the number value formatting again e.g.) as %, 2 decimal places and to be honest it is very annoying. What is the solution to this - I am hoping there is a way to lock the formatting allowing me to add and re-add.

Tables won't be in the same format and structure so formatting selected cells isn't an option.

Thanks in advance - any solution will be a big time saver!

Excel version is Office Professional 2013

Hi Rorya, thanks for the reply. This seems such a gap that Excel doesn't do this and surely must be driving other people crazy. Maybe the only answer is to have a duplicate pivot with all field on top copy from and then just remove the ones I don't need so the format sticks for the ones already in there but seems a pain! I will look into Power Pivot