Skip to Content
avatar image
Former Member

Context selection directly goes to excel direct edit mode

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

3jyx7.png (2.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Oct 24, 2016 at 08:47 AM

    User options - enable dowble click!

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2016 at 09:14 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      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

  • avatar image
    Former Member
    Oct 24, 2016 at 09:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2016 at 09:22 AM

    Also check sheet options:

    for this sheet!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2016 at 10:09 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2016 at 10:21 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded