Thursday, October 16, 2014

Right Click not working in Excel if Essbase Spreadsheet add-in is installed

The age old issue still haunts.
Although Excel addin has been excluded from EPM now, developers (and pro users) still use it for it is amazing versatility and speed.

It might just happen that your right-click may or may not work after you install Excel Spreadsheet add-in. The solution is very simple.

In Essbase addin ribbon, click on Essbase Options and uncheck 'Enable Secondary Button' , this option basically treats the other button (right button) of your mouse as the primary one (left button).



If doing this doesn't solve your problem, I suggest disabling all external add-ins in excel and checking if that works, Then go on enabling addins one by one to check which one is causing problems.

Cheers !
NJ

No comments: