Home

Pivot tables connected

%3CLINGO-SUB%20id%3D%22lingo-sub-664653%22%20slang%3D%22en-US%22%3EPivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664653%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3EHello%2C%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3EI%20created%20two%20pivot%20tables%20in%20different%20worksheets%20of%20a%20same%20workbook%2C%20but%20I%20am%20facing%20some%20problems%20when%20I%20try%20to%20group%20or%20ungroup%20only%20one%20of%20them.%20Because%20both%20tables%20have%20time%20as%20lines%2C%20whenever%20I%20try%20to%20group%20the%20days%20into%20months%20in%20one%20pivot%20table%2C%20the%20other%20one%20gets%20automatically%20grouped%2C%20which%20is%20a%20problem%20for%20the%20graphing%20results%20I%20am%20showing.%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3EHow%20can%20I%20have%20the%20freedom%20of%20grouping%20and%20ungrouping%20one%20pivot%20table%20without%20altering%20the%20other%20one%3F%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-664653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivot%20tables%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETables%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-664815%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664815%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325044%22%20target%3D%22_blank%22%3E%40GbiKripka28%3C%2FA%3E%26nbsp%3Byou%20might%20such%20issue%20if%20you%20have%20copy%20pasted%20a%20Pivot%20table.%20Try%20creating%20two%20separate%20Pivots%20from%20original%20data.%20I%20just%20tested%20with%20your%20scenario%20and%20it%20works%20perfectly%20for%20me.%20If%20you%20still%20face%20the%20issue%2C%20please%20share%20the%20file%20here.%3CBR%20%2F%3ENote%3A%20I%20am%20using%20office%202016%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-664998%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664998%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F353690%22%20target%3D%22_blank%22%3E%40bhushanz%3C%2FA%3Ethank%20you%20for%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunalely%20I%20created%20the%20two%20pivot%20tables%20separatedly%20and%20still%20it%20does%20not%20work.%20I%20will%20attach%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-665781%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-665781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325044%22%20target%3D%22_blank%22%3E%40GbiKripka28%3C%2FA%3E%26nbsp%3B%2C%20you%20created%20your%20Pivot%20Tables%20without%20adding%20data%20to%20data%20model.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20385px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117046iFBB697AA2DD98835%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20such%20case%20you%20need%20to%20separate%20Pivot%20Table%20caches.%20More%20details%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fpivot-cache-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fpivot-cache-excel%2F%3C%2FA%3E%20and%20in%20many%20other%20places.%20IMHO%2C%20with%20that%20better%20to%20create%20every%20new%20Pivot%20Table%20with%20old%20wizard%20Alt%2BD%2BP.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEven%20more%20better%20if%20you%20add%20data%20to%20data%20model%2C%20when%20caches%20will%20be%20separated%20automatically.%20Plus%20data%20model%20potentially%20gives%20you%20much%20possibilities%20to%20work%20with%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBoth%20variants%20are%20in%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-667611%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3Ethank%20you!%20Now%20it%20worked%20perfectly%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-668720%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20connected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-668720%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325044%22%20target%3D%22_blank%22%3E%40GbiKripka28%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
GbiKripka28
Occasional Contributor

Hello,

I created two pivot tables in different worksheets of a same workbook, but I am facing some problems when I try to group or ungroup only one of them. Because both tables have time as lines, whenever I try to group the days into months in one pivot table, the other one gets automatically grouped, which is a problem for the graphing results I am showing.

How can I have the freedom of grouping and ungrouping one pivot table without altering the other one?

 

Thank you

5 Replies

@GbiKripka28 you might such issue if you have copy pasted a Pivot table. Try creating two separate Pivots from original data. I just tested with your scenario and it works perfectly for me. If you still face the issue, please share the file here.
Note: I am using office 2016

@bhushanzthank you for your help

 

Unfortunalely I created the two pivot tables separatedly and still it does not work. I will attach the file.

 

Thank you

 

 

@GbiKripka28 , you created your Pivot Tables without adding data to data model.

image.png

In such case you need to separate Pivot Table caches. More details is here https://trumpexcel.com/pivot-cache-excel/ and in many other places. IMHO, with that better to create every new Pivot Table with old wizard Alt+D+P.

 

Even more better if you add data to data model, when caches will be separated automatically. Plus data model potentially gives you much possibilities to work with data.

 

Both variants are in the attached file.

@Sergei Baklanthank you! Now it worked perfectly

@GbiKripka28 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies