cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to use EPM Excel add-in

Former Member
0 Kudos

Dear friends,

The problem that I encounter is that I cannot open the dialog box once double-clicked in any relevant cell. Instead, it shows me a formula. Please see below.

Can anyone tell where the problem lies?

Many thanks in advance!

Elchin.

Accepted Solutions (1)

Accepted Solutions (1)

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Elchin,

Have you enabled "Double-Click" in user options?

Shrikant

Shrikant_Jadhav
Active Contributor
0 Kudos

P.S.

Options -> User Options -> Navigation -> Enable Double-Click

Former Member
0 Kudos

Dear Shrikant,

Yes, I have.

I have also noticed, that I cannot save any data, since the Save button is GREY. Can these two be related?

meenubansal87
Participant
0 Kudos

Hi Elchin

These 2 options are not related. Please check "Use as Input form" to enable Save button.

Regards,

Meenu

Former Member
0 Kudos

Hi Meenu,

Where should I check "Use as Input Form"?

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Elchin,

Make sure that you are logged in to system.

Kindly share the full screen shot of template .

Shrikant

Shrikant_Jadhav
Active Contributor
0 Kudos

Options -> sheet options - >General - Data input - > USe as input form

Kindly go through the basic documents of BPC

Shrikant

Former Member
0 Kudos

Dear Shrikant,

I have checked it and I am logged in to the system,  but still I have the same issue, the dialog box is not opened once double-clicked.

Shrikant_Jadhav
Active Contributor
0 Kudos

are you trying to double click on dimension which is in Page axis ?

Try to clear meta data cache and log off, close excel, log in , and check same template or create new

meenubansal87
Participant
0 Kudos

Hi Elchin,

To enable Save button got to Options->Sheet Options->General - Data input->Use as input form.

And to enable double-click, make sure that in Excel Options->Advanced->Display options for this worksheet->Show formula in cells instead of their calculated results is uncheck, then only you will be able to double-click on the cell and get the desired results i.e. EPM Member Selector.

Regards,

Meenu

Former Member
0 Kudos

One last question. How to clear meta data cache?

Former Member
0 Kudos

Dear Meenu,

Thank you very much, now Save button is enabled!

But double-clicking issue still remains. In Company Code cell once double clicked the new dialog box should have appeared so that we can choose a Code. But instead, you see that as if I have pressed F2 to edit the cell.

Your proposal did not solve this problem, alas.

Shrikant_Jadhav
Active Contributor
0 Kudos

EPM -> More -> Clear metadata Cache

Former Member
0 Kudos

It didn't work out. Thank you for all your time and patience!

meenubansal87
Participant
0 Kudos

Hi Elchin,

Try this - check the format of the cell, if it is "Text" change it to "General".

Regards,

Meenu

Former Member
0 Kudos

Hi Elchin,

Kindly check that is there are any microsoft updates are installed (KB2553154). If theseupdates are installed then try to uninstall the  Microsoft update "Security update and restart your PC


Also go through below links.

Sushant

Former Member
0 Kudos

Thank you my friend, it was a problem of Microsoft update. Now I have fixed it thanks to the links provided above.

All the best!

Answers (0)