EPM Client installation not possible on O365 2016 Client

[Former Member]

SAP BPC 10.1 MC - Office 365 Excel 2016

EPM Add-in for Microsoft Office installation

Components are required

Microsoft Visual Basic for Application 2016 or later

How can I install it ?

[Marc_Kuipers]

Hello Dolinda

There is an issue with Office 365, whereby you cannot add the VBA anymore as described here:

http://www.ispringsolutions.com/blog/installing-vba-component/

When you select "Change" in 365, you only get this option

The result of all this, is that Office 365 does not install the PIA (Primary Interop Assembly) anymore and you will probably get an error like this

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

At the moment, the only workaround is this:

https://service.sap.com/sap/support/notes/2403397

Hope this helps

Marc

[former_member186338]

Not sure that this note is about VBA missinng...

The registry key to be checked:

https://support.microsoft.com/en-us/help/281954/how-to-turn-off-visual-basic-for-applications-when-y...

P.S. By the way, in MS Office 2016 VBA 7.1 is used (from Office 2013)

The following link may be useful:

https://blogs.sap.com/2014/08/11/installing-epm-add-in-on-microsoft-office-2013/

[former_member186338]

"Microsoft Visual Basic for Application 2016" Open MS Office in Programs and add this component! What's the issue?