Pivot Table Issues

How to Disable the Quick Explore Pop-Up in Excel PivotTables

Bushra ParveenBushra Parveen Nov 18, 2026 869 views

Question details

The user wants to stop or reduce the Quick Explore pop-up while using an Excel PivotTable.

How to Disable the Quick Explore Pop-Up in Excel PivotTables
Product
Microsoft Excel PivotTable and Power Pivot
Device & OS
not provided
Scenario
The user is analyzing data or presenting a workbook that contains a PivotTable.
Observed behavior
A Quick Explore pop-up appears during PivotTable interaction and interrupts the user's workflow.
Before you start

Select the affected PivotTable and identify whether the interruption is Excel's Quick Explore button or a separate add-in pop-up. Available PivotTable settings and add-in controls can vary by Excel version.

Solution 1Recommended

Reduce Quick Explore Interruptions in the PivotTable

Use this workaround when Excel's built-in Quick Explore control appears during analysis or a presentation.

Excel does not offer a universal setting to disable the built-in Quick Explore control in every version. PivotTable display options may control other buttons or tooltips without turning off Quick Explore.

1
Review PivotTable options

Click inside the PivotTable, then open PivotTable Analyze > Options and select the Display tab. Review the available display settings in your Excel version.

2
Check the available controls

If your version offers a setting specifically labeled for Quick Explore, turn it off and click OK. Do not assume that a tooltip or expand/collapse button setting also disables Quick Explore.

3
Move the selection

If no Quick Explore setting is available, click a cell outside the PivotTable after making a selection. During a presentation, avoid selecting PivotTable data cells unless you need to explore them.

Reduce Quick Explore Interruptions in the PivotTable
Settings vary by version: The selection workaround reduces interruptions but does not permanently disable Quick Explore.
Free Microsoft Office alternative

Work with PivotTables in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for spreadsheet work. Open compatible Excel files in WPS Spreadsheets to move your workflow across easily; it does not change Excel's Quick Explore setting.

Review and analyze spreadsheet data with PivotTable toolsOpen and save Microsoft Excel formats, including XLSX and XLSUse a familiar spreadsheet interface for everyday tasksMove compatible files from Microsoft Office without a complex migration
microsoft office alternative - wps office

Frequently Asked Questions

Is there a setting to turn off Quick Explore in every Excel version?

No universal setting is available across all versions. Select the PivotTable and check PivotTable Analyze > Options > Display for controls available in your build.

Will disabling Power Pivot turn off Quick Explore?

Not necessarily. Quick Explore is an Excel PivotTable feature, and disabling the Power Pivot add-in may limit Power Pivot tools without removing the control.

How can I keep the control out of the way during a presentation?

After interacting with the PivotTable, click a cell outside it. Avoid selecting PivotTable data cells when you do not need to explore the data.

Where can I check whether an add-in is causing a pop-up?

Go to File > Options > Add-ins. To test a COM add-in, select COM Add-ins under Manage, click Go, and temporarily clear the suspected add-in's checkbox.