Skip to Content
0

EPM Client installation not possible on O365 2016 Client

Mar 09, 2017 at 11:10 AM

520

avatar image

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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Mar 09, 2017 at 11:28 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Marc Kuipers
Mar 09, 2017 at 07:34 PM
0

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


Show 1 Share
10 |10000 characters needed characters left characters exceeded

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-you-deploy-office

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/

0