EPM Add-In for MS Excel 2007 - cannot change context in drop-down

[Former Member]

We are running SAP BPC 10.1 on HANA, and the users are running Office 2007 and the EPM Add-In is 10.0 SP 23 Patch 2 .NET 3.5.  Most of our users have the EPM Add-In for MS Excel delivered via Citrix, but some of our users also have a local install of the EPM Add-In (same versions).

I have a user who had opened a report from the server with his local install and could not change the context in the report.  He would click on the drop-down and either click on a recently selected member in that particular dimension or click to select other items.  In either case the drop down would disappear and would remain at the originally selected item.  There would not be a pop-up window to allow him to select another item.

We tried refreshing the meta data, and that did not work.

I could open the same report from my local install and it worked just fine.

I had him try the Citrix connection, and it worked just fine for him, there.

So, it seems it is either related to his install or some sort of cache somewhere.  It does not seem related to his profile or to the report.

I've not see anything in SCN that will help me troubleshoot this.

Does anyone have any suggestions?

Do you need any add'l information from me to help troubleshoot this?

In case it matters, this is a standard / classic environment he is trying to access.

Jeff

[Former Member · Accepted solution]

HI Jeff,

As it is working fine in Citrix and your local machine, I assume that the problem is with the Microsoft office and security updates on the users system where is it is not working. There are many threads for the issues with MS updates during the last year. SAP also suggested few solutions. search with key word for MS updates issues in EPM.

I would recommend to have your office to 2010 version or higher to avoid such issues.

You can try this,

Go C drive in the users system and search for .exd files and delete all the files with that extension. and restart the system. I guess it must work. Let me know if it does not.

Thanks

[Former Member · Accepted solution]

We tried deleting all EXD files, and that did not resolve the issue.  We are going to simply try to uninstall and reinstall the add-in, to see if that works.  There are other add-ins the user is using, and there are some Office 2007 updates they have on their machine that I do not have (for InfoPath, Publisher, and Access), and one update I have that they do not have.  I may see if I can get the update pushed to him that I have and he does not, however, that is much more involved than simply removing and re-installing.

[Former Member · Accepted solution]

reinstallation of epm add-in did not resolve the issue...

[Former Member · Accepted solution]

Hi Jeff,

Any software difference between your machine and his machine? eg, office and EPM add in version.

also make sure the correct patches are installed in the machine, see note 2107965

what you can try is by open that report or inputsheet in your machine and save it again, and try open on his machine again.

Andy

[Former Member · Accepted solution]

Hi Jeff,

Any other excel add-ins install on user's machine which is not installed on Citrix and your machine ?

Also check user options (compare with your user options)

temporary solution is:

1) Go to Options --> User Options --> Others --> Enable Manual entry of Members

this will allow the user to type the member in context.

Thanks

Obaid

[Former Member · Accepted solution]

Thank you, Andy.  Let me try saving the file on my machine and then have him try.

He also has some other add-in for Excel that I need him to disable and see if that resolves the problem, but that requires him working with other IT resources who have local admin rights to his machine.

[Former Member · Accepted solution]

Thank you for the help, Obaid.

I've tried the manual entry, and that does not work.  When you type something in and hit Enter, it just goes back to the previous member and nothing changes.