Disable double click on pivot data

[MohitMathur1234]

Hi,

I need a small help. I have pivot table but I want, user can not double click on data.(If someone double click on data so it automatically create a new sheet and display details)
I dont want user can double click on data.
How to disable this double click functionality?

 

[bobhc]

You may find these links of help.

https://support.office.com/en-gb/ar...t-report-0cae5f7a-fee9-4f66-8b76-06bad6cdb14d


http://answers.microsoft.com/en-us/...t/f750860c-ec9c-455f-94e3-4c151e8a91cd?auth=1


.

 

[MohitMathur1234]

Thanks you.. I got the answer.!!