Hello!

I am a student taking a spreadsheet class right now so I'm not totally sure about these features. But, here's the breakdown of my issue. Oh, I am using a free trial of Office 365 ProPlus right now.

Textbook tells me to open the PowerPivot window and click Manage. From there, I get external data from an Access database. Once that is done, it says to insert a PivotTable on a new worksheet and then drag certain fields to the Columns/Rows/Values sections. All of this works great for me.

Now, it tells me to click a certain cell and click the Quick Explore icon at the bottom right corner of the cell (much like the Quick Analysis button does). However, it doesn't matter what cell I click, the quick explore button does not appear. At all. I tried to bypass it and go to drill down in the Analyze tab, but the drill down and drill up buttons are inactive and shaded.

I have no idea why this is happening and I have retraced my steps several times to make sure I am not missing anything. I though maybe there's an option that has to be enabled for that, but from what I can tell, it's just standard. Any suggestions?

Thanks!!!

Hi,

Could you please let us know how did you create the pivot table?

In Excel 2013, the new Quick Explore feature lets you drill into your Online Analytical Processing (OLAP) cube or Data Model based PivotTable hierarchy - to analyze data details on different levels. So you need to create a PivotTable from PowerPivot window, not from Insert > PivotTable. PowerPivot provides more advanced modeling capabilities for more experienced data modelers.

Also if you want to use the Drill Down/Drill Up feature, you need to create a hierarchy in PowerPivot.

Below is a screenshot of the final Pivot Table you should see in Excel.

For more detailed information, please refer to:
http://office.microsoft.com/en-001/excel-help/drill-into-pivottable-data-HA102840029.aspx

If the information above doesnt help, please share your workbook with us.

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, July 07, 2014 3:11 AM

I have exactly the same problem, the difference is that in my case, we have implemented a DataWare House using SQL2014 and SAS, on a computer with the same version of Windows and Office, specifically 15.0.4745.1000 32bit quick explore icon appears, in another computer with the same user, excel and Windows, does not come out. I have no idea what the problem