SOLVED

pivot table behavior related information required

%3CLINGO-SUB%20id%3D%22lingo-sub-1864607%22%20slang%3D%22en-US%22%3Epivot%20table%20behavior%20related%20information%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864607%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20one%20excel%20workbook%20.%3C%2FP%3E%3CP%3Eone%20table%20as%20source%20data%20and%20created%20many%20pivot%20tables%20with%20this%20same%20source%20data.%20in%20the%20same%20work%20book.%3C%2FP%3E%3CP%3Ewhen%20i%20change%20the%20date%20format%20in%20group%20%2C%20it%20changes%20in%20all%20pivot%20tables%20.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20some%20pivot%20tables%20i%20want%20to%20show%20it%20as%20year%2C%20and%20in%20some%20other%20as%20month%2C%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20to%20stop%20changing%20all%20the%20pivot%20tables.%20only%20one%20should%20change%20where%20i%20made%20change.%3C%2FP%3E%3CP%3Ebest%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1864607%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1865131%22%20slang%3D%22en-US%22%3ERe%3A%20pivot%20table%20behavior%20related%20information%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865131%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F782935%22%20target%3D%22_blank%22%3E%40ndmalam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcelunplugged.com%2F2013%2F06%2F05%2Fhow-do-i-separate-pivottables%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EHow%20do%20I%20%E2%80%9Cseparate%E2%80%9D%20Pivot%20Tables%3C%2FA%3E%26nbsp%3Bor%20other%20similar%20blogs%20on%20how%20to%20separate%20PivotTable%20caches.%20In%20general%20it's%20better%20to%20work%20using%20data%20model.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

1 Reply
Best Response confirmed by ndmalam (Occasional Contributor)
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.