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.
Bookmarks