Currently I am using Microsoft Office 365 at work, version 2102 (Build 12801.21278)
Steps: Execute query> copy results and paste into new workbook>Insert Pivot table on all data>add columns and rows
When using a Pivot table in 365, if I attempt to double click a cell to show the records behind that value, it is opening a new sheet with ALL the data (5000+ rows) where I only expect to see the 6 records behind the pivot table's cell value I selected.
Coworker uses Office 2016:
If my coworker opens the same workbook I created from a shared drive and attempts to perform the same function, the results are the same.
However, when I use my coworkers PC (Microsoft Office 2016) and perform the identical steps used above to create a new workbook, double clicking the value in the Pivot Table's cell works perfectly and only displays the results from that cells value.
If I open the workbook he created using Office 2016 via my Micro 365, I am able to double click the pivot table cell value and ONLY see the results of that cell value which is the way it should be.
Is there some default setting for how Pivot Tables work in this regard within Micro 365 that I am missing? Considering I was able to prove it was only an issue when the workbook was created using Micro 365, there has to be something in OPTIONS I am not seeing.
Thank you!!
Steps: Execute query> copy results and paste into new workbook>Insert Pivot table on all data>add columns and rows
When using a Pivot table in 365, if I attempt to double click a cell to show the records behind that value, it is opening a new sheet with ALL the data (5000+ rows) where I only expect to see the 6 records behind the pivot table's cell value I selected.
Coworker uses Office 2016:
If my coworker opens the same workbook I created from a shared drive and attempts to perform the same function, the results are the same.
However, when I use my coworkers PC (Microsoft Office 2016) and perform the identical steps used above to create a new workbook, double clicking the value in the Pivot Table's cell works perfectly and only displays the results from that cells value.
If I open the workbook he created using Office 2016 via my Micro 365, I am able to double click the pivot table cell value and ONLY see the results of that cell value which is the way it should be.
Is there some default setting for how Pivot Tables work in this regard within Micro 365 that I am missing? Considering I was able to prove it was only an issue when the workbook was created using Micro 365, there has to be something in OPTIONS I am not seeing.
Thank you!!
