Pivot Table Issues

Fix Quick Explore Option Missing in Excel PivotTables

Bushra ParveenBushra Parveen Oct 20, 2026 869 views

Question details

The user is unable to find or access the Quick Explore (drill-down) option when interacting with categories in an Excel PivotTable or PivotChart.

How to Fix Quick Explore Missing in Excel PivotTables
Product
Microsoft Excel (Home and Student 2021)
Device & OS
not provided
Scenario
Attempting to drill down into specific data categories within a PivotTable or PivotChart using the Quick Explore feature.
Observed behavior
The Quick Explore option does not appear in the right-click context menu or when selecting categories, even though the feature works for other users opening the same source file.
Before you start

Ensure you are opening the exact same source file as the users who can see the feature, and confirm that your file is saved in the modern .xlsx format, as older formats may not support Data Model features.

Solution 1Recommended

Verify Hierarchical Data in the PivotTable Data Model

The Quick Explore feature requires the PivotTable data model to contain a defined hierarchy. Creating this hierarchy allows Excel to understand how to drill down into the data.

Quick Explore is specifically designed to work with Online Analytical Processing (OLAP) cubes or Excel Data Models that have built-in hierarchies (e.g., Year > Quarter > Month). If the data is just a flat table or the hierarchy isn't explicitly defined, the option will be hidden.

1
Open Power Pivot

Click on the 'Power Pivot' tab in the Excel ribbon, then click on 'Manage' to open the Data Model window.

2
Switch to Diagram View

In the Power Pivot window, look at the Home tab and click on 'Diagram View' located in the View group on the far right.

3
Create a Hierarchy

Locate the table used for your PivotTable. Use the 'Create Hierarchy' button in the table header, name the hierarchy, and drag related fields (like Year, Quarter, Month) into it.

4
Refresh PivotTable

Close the Power Pivot window, return to your Excel sheet, right-click inside your PivotTable, and select 'Refresh'. Check if the Quick Explore option is now available when you select a category.

Verify Hierarchical Data in the PivotTable Data Model
Power Pivot Add-in: If you do not see the Power Pivot tab, you may need to enable it by going to File > Options > Add-ins > Manage COM Add-ins > Go, and checking 'Microsoft Power Pivot for Excel'.
Free Microsoft Office alternative

Try WPS Office for Powerful Data Analysis and Pivot Tables

If your current Excel Home and Student edition lacks the advanced features you need or restricts your workflow, consider switching to WPS Office. It provides a robust, lightweight, and completely free alternative for processing complex spreadsheets and standard PivotTables without expensive licensing hurdles.

  1. 1. Download and Install: Get WPS Office for free from the official website and run the quick installer.
  2. 2. Open Your Workbook: Launch WPS Spreadsheet, click 'Open', and select your existing .xlsx file.
  3. 3. Analyze Data Seamlessly: Highlight your data and go to the 'Insert' tab to create and manage PivotTables effortlessly.
Fully compatible with Microsoft Excel (.xlsx) formats and standard PivotTables.Lightweight installation and incredibly fast loading times for large datasets.Familiar user interface with no steep learning curve.Completely free core spreadsheet features without version-restricted limitations.
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Quick Explore option grayed out or missing in Excel?

Quick Explore is only available when your PivotTable is connected to an OLAP cube or an Excel Data Model that contains explicitly defined hierarchies. If your data is built from a simple flat range or lacks a hierarchy, the option will not appear.

Can I use Quick Explore in Excel Home and Student 2021?

Excel Home and Student editions may have limitations regarding advanced Data Model and Power Pivot features. If the workbook relies on business intelligence tools exclusive to Microsoft 365 ProPlus or Enterprise editions, Quick Explore might be unavailable.

How do I add a hierarchy to my Data Model in Excel?

You can add a hierarchy using the Power Pivot add-in. Open the Power Pivot 'Manage' window, switch to 'Diagram View', find your data table, click 'Create Hierarchy', and drag your related fields (like Year and Month) into the new hierarchy.