Skip to Content
Author's profile photo Lingaiah Vanam
Lingaiah Vanam
April 4, 2017 Less than a 1 minute read

EPM Add-In Error after upgrading office 2016 or 365

Hi IBP Consultants,

After upgrading to Microsoft Office 2016 or 365 the following error occurs when trying to logon to EPM Add-in:

The type initializer for ‘FPMXLClient.ReportManagement.FormattingSheet’ threw an exception. Could not load file or assembly ‘Microsoft.Vbe.Interop.Forms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. The system cannot find the file specified.

Resolution

1. Install MS Office 2013 on a separate machine or check a working machine
2. In the folder %windir%\assembly\gac or %windir%\assembly\GAC_MSIL there will be a subfolder called : “Microsoft.Vbe.Interop.Forms”

3. Copy this directory and contents to the affected machine (running Office 2016)
4. Restart Excel, the EPM Add-in will allow log on.

Best Regards,

Lingaiah

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Dan Banning
      Dan Banning

      What are the chances of SAP including the dll as part of the IBP Excel add-in install file?  The large corporate IT organizations I am dealing with are not cooperative when it comes to manually copying over dll files and playing around with the registry.

      It does look like SAP includes the files in the EPM Add-in for Microsoft 10.0 SP28 Office Patch 01

      Dan