![]() |
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, |
All times are GMT +1. The time now is 02:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com