Pivot - Turn off 'click-through' functionality

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
 

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
Turning Data into a Table 1
Consolidate Pivot Tables/Cache using Excel 2003 1
Parent of item in Pivot table 1
Adding Report Filters to Excel Pivot Tables via VB. 1
Pivot Table Help 1
Pivot Table Defaults Turn Off Subtotal 2
pivot table loosing decimals (vba) 1

Top