Hi all,

I preparing a multiple pivots from single source data and these pivots are build in different sheets individually.

But everytime i refresh the pivot with new data, the grouping, filters and formats gets changed for all pivots. I have tried to remove the tick mark for auto format in the pivot options but still the issue persist.

Can anyone help me to resolve the issue.

thanks.