Re: Drill - down Sheets In New Files ( pivot Table ) jigar987, As far as I know it is not possible to change the root behavior of the pivot table you can do
Pivot Table Drill Down Click here to reveal answer. ... We've detected that you are using an adblocker. We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
However, you may want a user NOT to be able to accidentally or otherwise drilldown into the data. There is a small setting we can change to prevent this. Select your PivotTable Go to the Analyze tab in the ribbon Press the Options button in the PivotTable section to open the options menu
Hello there, so I have a workbood with a bunch of queries. I connected them in a reasonable way and set up my PowerPivot table. I was playing around with the pivottable a bit and at some point I was trying to double click the values in the table to drilldown and receive a table of the appropriate values. However I only get the hourglass for 2 seconds and then nothing happens at all.
I have been using my power pivot file and drilling down and after re-configuring the rows the drilldown function stopped. I set it back to the way it was and it still didnt work. I double check that all the data was coming from the same table. My other Power Pivot files connected to the same data still works.