Skip to Content
avatar image
Former Member

Add-in Ribbon won't stay in Excel

Hi,

I wonder if anybody had similar experience and any solution to this.

Normally the S&OP / IBP ribbon will appear in Excel at launch, on occasion when Excel disabled the Add-in, user can enable it back manually with File / Options / Add-in / Manage - COM Add-in.

For a small number of our users, every time when they open up Excel, the S&OP Add-in ribbon is disabled by default, so they have to go through the path every time to enable it.

Is there a way to make sure the S&OP Add-in button stays enabled at launch of Excel?

Thank you.

Yee Ann


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 09, 2015 at 09:59 PM

    Hello Yee Ann,

    Just saw the same thing with a colleague running Office 2013 on Windows 8.1 - he's the first to experience it here at SAP.

    With my colleague we fixed the situation (for now) by switching the load behavior from 0 to 3 in the registry (the installer should set it to 3 - haven't figured out how it became 0 yet). Other tips may be found in note http://service.sap.com/sap/support/notes/1645616.

    To modify the registry:

    • regedit.exe
    • Navigate to path Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\FPMXLClient.Connect
    • Right-click on LoadBehavior, select Modify
    • Change value from 0 to 3

    We'll keep an eye on it to see if we can understand what caused the situation.

    Cheers,

    Cora


    ScreenShot-03.png (54.3 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 24, 2016 at 09:46 AM

    Hi,

    One of our users having similar kind of issue and she has followed the exact steps but it didn't get solve.

    The LoadBehavior was already set to 3 under FPMXLClient.Connect and was never 0 but still the IBP icon disables every time.

    Please help

    Add comment
    10|10000 characters needed characters exceeded