Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show / hide data by seeing if a field says "Yes" | Excel Discussion (Misc queries) | |||
Pivot Table - Remove "sum of" in data field | Excel Discussion (Misc queries) | |||
"Show Field List" in Pivot Table Toolbar doesn't work | Excel Discussion (Misc queries) | |||
Pivot table "Show all data" query | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) |