Hi

I have a Pivot table which I sometimes change its layout, meaning: selecting different columns, moving columns between the report areas (Values, labels etc)
The problem is that Excel does not remember the selected settings for a given layout

For example:
Assuming I have selected column Col1 to be displayed as values. I changed the default from Count to Average, changed its column header, format the numbers etc.

Now I choose to display different layout Say Col2, Col3
When I need to display Col1 again - I have to set again, all the settings I described above

Is there a solution to that?

tx