Forum Discussion
Pivot tables connected
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, w...
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.
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.
SergeiBaklanthank you! Now it worked perfectly
GbiKripka28 , you are welcome