Skip to Content

How to disable filtering member by using double-click

Nov 01, 2016 at 08:08 PM


avatar image
Former Member


I disabled the ribbon and context menu in Analysis for Office for Excel so that users cannot filter members. However, I found out that we can still do it by using double-click.

Does somebody know how to disable the filtering by double-clicking, or how to return to original output even after users filter members, without enabling the ribbon and context menu?

I am using Analysis for Office 2.3 SP2.

Thank you,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Stephen Hobbs Nov 02, 2016 at 09:32 AM

Hi Asa,

You can make a setting change in the Ao_user_roaming.config file. It's detailed in the Administrator Guide but I've also added it to this post...



double-click.jpg (36.2 kB)
10 |10000 characters needed characters left characters exceeded