How to Disable the Quick Explore Pop-Up in Excel PivotTables
Question details
The user wants to stop or reduce the Quick Explore pop-up while using an Excel PivotTable.

- 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.
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.
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.
Click inside the PivotTable, then open PivotTable Analyze > Options and select the Display tab. Review the available display settings in your Excel version.
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.
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.

Check Excel Add-ins for a Separate Pop-Up
Use this check if the pop-up appears to come from Power Pivot or a third-party add-in rather than Excel's built-in Quick Explore control.
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.

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.




