EPM Add-in error "Could not load file or assembly 'Microsoft.Vbe.Interop.Forms"
W
Will Hunt
started a topic
about 1 year ago
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.
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"
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.
Will Hunt
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.
Office365 is not installing the PIA (Primary Interop Assembly) anymore.
- 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.
Microsoft Visual C++ 2010 is not installed.
Install these components to fix this issue:
http://www.microsoft.com/download/en/details.aspx?id=5555
OR
http://www.microsoft.com/download/en/details.aspx?id=14632