Skip to Content
avatar image
Former Member

excel add-in

Hi experts

I was trying to log in in to the system but after log in The following format is displayed

The type initializer for 'FPMXLClient.ReportManagement.FormattingSheet' threw an exception.

does any know how to fix it?

Jorge

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Best Answer
    Jan 11, 2017 at 05:06 PM

    Hi Jorge,

    Please be aware that the plugin is officially supported by Office 2010 and 2013 (https://launchpad.support.sap.com/#/notes/0002135948). However, in case you installed 2016, you can try to install Office 2010 along with 2016 in the same machine and see if the connection works as expected.

    Best regards,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2017 at 07:49 PM

    Hi Jorge,

    Is it happen right after clicking to logon in Excel UI? Is it possible to keep using IBP ribbon after you click OK in the error message? It would be great if you can attach a screenshot for reference as well.

    Thanks,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 03:50 PM

    Hi Jorge,

    The root cause might be your Microsoft Office or .NET. If you installed Microsoft office 365, try to install 2010 also along with 365.

    Check your Excel Addin also compatible with IBP version.

    You will not get this error, let me know if you need any issue after installing additional office.

    Best Regards,

    Lingaiah

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 04:23 PM

    Hi Lingaigh

    Thanks for your answer now i instaled office 2016 you i need to install 2010 too?

    Best Regards

    Jorge

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 04:41 PM

    Hi Jorge,

    Please install 2010 too and try to access IBP.

    Best Regards,

    Lingaiah

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 07:19 PM

    Hi Ivan

    I though the root cause is .NET frame work too. So I have checked the 4.6.1 DOT NETWORK and it is installed on my machine s per the above OSS note 2135948. Still I have reinstalled the entire windows10 and reinstalled the office 2016 on my machine today morning. I re-added the IBP plugin but I still had the same problem.

    Seems like the next thing to do is the Office 2010. Any other option than Office 2010 install ?

    Thanks

    Durga

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Durga,

      As in Jorge's case, I would suggest that you install Office 2010 along with 2016 to check if it will work for you, since the plugin is only officially supported for Office 2010/2013 versions.

      Please let us know the results.

      Thanks,

      Ivan

  • avatar image
    Former Member
    Jan 11, 2017 at 11:25 PM

    Hi Ivan

    Thank you. On a side note, I have added the IBP Addin on a different Desktop with WINDOWS 10 and Office 2016. It worked absolutely fine. Its really a puzzle why it is not working for me on this laptop. I will get the Office 2010 and install it and check it.

    Thanks

    Durga

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 11:49 PM

    Hello Every one

    Who ever is looking for solution. I have used the solution explained in the following note and resolved the issue and now I am able to login.

    2403397 - EPM Add-in error "Could not load file or assembly 'Microsoft.Vbe.Interop.Forms

    No need to install the 2010 Office version. It will work with 2016 also.

    Thanks

    Durga

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 11:49 PM

    Hello Every one

    Who ever is looking for solution. I have used the solution explained in the following note and resolved the issue and now I am able to login.

    2403397 - EPM Add-in error "Could not load file or assembly 'Microsoft.Vbe.Interop.Forms

    No need to install the 2010 Office version. It will work with 2016 also.

    Thanks

    Durga

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 06:38 PM

    Hi Every one

    Thanks for all your help its works i had to installed the office 2016 and 2010 and its works thats every one

    Best Regards

    Jorge

    Add comment
    10|10000 characters needed characters exceeded