pivot table behavior related information required

[ndmalam]

I have one excel workbook .

one table as source data and created many pivot tables with this same source data. in the same work book.

when i change the date format in group , it changes in all pivot tables . 

In some pivot tables i want to show it as year, and in some other as month, 

how to stop changing all the pivot tables. only one should change where i made change.

best regards

[#2 · Accepted solution]

@ndmalam 

Please check How do I “separate” Pivot Tables or other similar blogs on how to separate PivotTable caches. In general it's better to work using data model.