Hide "Show details" when right click on data field in Pivot Table

A

Anh Tuan

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,
 

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

Top