Start a new topic

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



After upgrading to Office 2016 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=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.


Cause #1:

Office365 is not installing the PIA (Primary Interop Assembly) anymore.


Upgrade to latest EPM version.

- or -

You may want to use the workaround below if you don't want to upgrade your EPM Add-in or AO.

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


Note: if your assembly folder shows as follows:


You need to change the view as follows:

Launch regedit.Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\FusionAdd a DWORD called DisableCacheViewer and set the value to 1.

Then, restart windows explorer and use the procedure as described above.

Cause # 2:

Microsoft Visual C++ 2010 is not installed.

Login or Signup to post a comment