EPM Add-in error "Could not load file or assembly 'Microsoft.Vbe.Interop.Forms"
started a topic
about 1 year ago
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=220.127.116.11, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
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.