Context selection directly goes to excel direct edit mode

[Former Member]

Hello All,

We recently updated our EPM Add-in SP 22 to EPM add-in SP 26.

After upgrading we have one issue i.e. the EPM context member (EPMContextMemer function) selection is not working properly. The moment when we double click one epm context member selection it directly enabling edit mode in excel instead of opening member selector window.

Any one face this kind of issue or have any idea..?

Thank you very much in advance.

SRG

[Former Member]

Hi

PS.

If you have any VBA code and in that VBA code if someone added the above event as false then in that case before END SUB statement add one line to make that event as true so it will not have any impact on other template also, else every time you need to manually activate the event or every time you need to close all the excels.

[Former Member]

hi Saida,

I have faced this issue. The root cause was VBA But in your case you are saying that you don't have any VBA. Still I believe that this is happening because of the VBA. Close all excels then again open report and check. It will work properly. If this the case then issue is VBA.

I am able reproduce your problem.

Please follow bellow approach to reproduce the problem. If you block the excel event then it can happen.

1. close all excel
2. open new excel and connect to the system
3. Execute below code.
4. Type any EPM formula in excel.

Sub err()

Application.EnableEvents = False

End Sub

To solve the issue just enable the event

Sub solution()

Application.EnableEvents = True

End Sub

Hope this will help you to resolve the issue.

[former_member186338]

Also check sheet options:

for this sheet!

[former_member186338]

If it's not EPM Worksheet then EPM formulas will not work!

[Former Member]

Its also selected like mentioned above. please see the below image.

[Former Member]

Hi Saida,

Please can you check whether FPMXLClient.TechnicalCategory is enabled or not during the installations! Go to Excel Options ---> Add Ins--->Excel Add-Ins---> Go.

Check below screenshot!

Regards,

JPepmfunctions.png

[Former Member]

Hello JP,

Its also enabled please see the below screen shot.

[Former Member]

Is this the case with context member function only?? or all other functions too?

[Former Member]

All Select member also, overall yes for all functions its the same behavior.

[former_member186338]

Microsoft security updates?

[former_member186338]

Look on my sample everything is the same and it's working:

[Former Member]

Thank you very much for your prompt reply.. please see the attached details here below

[former_member186338]

Try to upgrade to Patch 3!

[Former Member]

yeah its seems it's the only option need to check...

Thank you very much ..

[former_member186338]

I assume you don't have any vba code in this file that may affect epm behavior!

[Former Member]

yes I don't have any VBA code, not even report also.

I opened my standard report, its also behaving like above so opened a plan and write a simple epm function its also behaving the same way.

[former_member186338]

Are you able to create a new simple report and refresh it?

Double click on page axis members is working?

[Former Member]

I checked it, any where in the layout double click directly goes to edit mode in excel.

in page axis also its not working, parent expansion also not working as expected.

Thank you very much

SRG

[former_member186338]

User options - enable dowble click!

[Former Member]

Its already endabled..

[former_member186338]

Please check again:

In my test with the same SP26 (NET4 big vol, patch 3) everything is working properly!

[Former Member]

yes its already enabled. please see here below.

[former_member186338]

Please provide SP details (NET, patch level...)