Pivot - Turn off 'click-through' functionality

  • Thread starter Thread starter Me!
  • Start date Start date
M

Me!

Hi,

Regarding the functionality in pivot tables that enables a user to
double-click any data item and have the underlying records dumped out in a
new sheet - does anyone know if there is a way to 'turn off' this
functionality.

Many thanks, .....Jason
 
Excel 2007 PivotTable
PT Options > Data > Enable show details
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - click through extract data formatting issue 1
Pivot Table Help! 1
Turning Data into a Table 1
Access #Error & Excel Pivot 0
Consolidate Pivot Tables/Cache using Excel 2003 1
Parent of item in Pivot table 1
Pivot Table Help 1
Adding Report Filters to Excel Pivot Tables via VB. 1

Back
Top