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