Start a new topic

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

Symptom:


 

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



image



Cause #1:

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


Resolution:

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"


image



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:


image



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