Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Hide "Show details" when right click on data field in Pivot Table

Dear Microsoft,
Please help me solve the problem that happen to me when use Pivot Table
(Excel 2007).
I have a Pivot Table like this:.

Data
AAA Infor. Count Sum
BBB HHH 23 256,962,305
NNN 23 256,837,275
Others 3 18,151,200
CCC HHH 206 3,255,545,500
NNN 52 902,285,045
Others 147 2,145,626,800
DDD HHH 22 497,000,000
NNN 6 126,000,000
Grand Total 482 7,458,408,125

In data field, when I make right-click on, it shows details form the result.

I would like to hide the fnction "show details" when right-click on data
field, how could I do this?

Please pay your attention that, I've already check out "Enable show detail"
in Pivot Table Options\Data tab. But, this makes Pivot Table not show detail
when right0click on data field. It still permit other users can enable this
function again.

So I'd like to protect this function by hiding this function. I don't know
how to do this. Please help me with this.

Thanks & regards,
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show / hide data by seeing if a field says "Yes" Joseph Hand Excel Discussion (Misc queries) 8 August 13th 07 09:32 PM
Pivot Table - Remove "sum of" in data field abgmclt Excel Discussion (Misc queries) 2 May 26th 06 08:22 PM
"Show Field List" in Pivot Table Toolbar doesn't work Flyer27 Excel Discussion (Misc queries) 0 April 12th 06 12:05 AM
Pivot table "Show all data" query Laurence Lombard Excel Discussion (Misc queries) 2 January 31st 06 09:24 AM
pivot table - hide details but show subtotal for calculated field tenneym Excel Discussion (Misc queries) 1 February 9th 05 03:07 AM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"