Skip to Content
0

Context selection directly goes to excel direct edit mode

Oct 24, 2016 at 08:35 AM

217

avatar image
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

3jyx7.png (2.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Vadim Kalinin Oct 24, 2016 at 08:47 AM
0

User options - enable dowble click!

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Its already endabled..

0

Please check again:

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

5vox6.png (16.0 kB)
0
Former Member
Vadim Kalinin

yes its already enabled. please see here below.

wdyal.png (34.6 kB)
0

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

0
Vadim Kalinin Oct 24, 2016 at 09:14 AM
0

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


nkyiz.png (74.1 kB)
Show 7 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

5koh8.png (37.7 kB)
0

Try to upgrade to Patch 3!

0
Former Member
Vadim Kalinin

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

Thank you very much ..

0

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

1
Former Member
Vadim Kalinin

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.

0

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

Double click on page axis members is working?

0
Show more comments
avatar image
Former Member Oct 24, 2016 at 09:17 AM
0

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


epmfunctions.png (9.9 kB)
Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello JP,

Its also enabled please see the below screen shot.

ofolt.png (22.6 kB)
0
Former Member
Former Member

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

0
Former Member
Former Member

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

0

Microsoft security updates?

0
Vadim Kalinin Oct 24, 2016 at 09:22 AM
0

Also check sheet options:

for this sheet!


fycqh.png (36.4 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0
Former Member

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

wfk6f.png (45.8 kB)
0
avatar image
Former Member Oct 24, 2016 at 10:09 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 24, 2016 at 10:21 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded