Analysis Office, EPM Plug-in and Excel 2016

[former_member349978]

Are there good resources available that describe the required Microsoft trust/security settings (or AO config settings) to allow the Analysis and EPM plug-ins to operate properly?

As we migrate from Office 2010 to Office 365 (Excel 2016 MSO 32-bit), we're running across a number of issues with interaction between the EPM plug-in and Excel 2016. We have seen the "Edit Report" and "Save Data" options grayed out, EPM context items unhidden, and reports that will not refresh. We have seen these issues on both AO 2.4 SP3 and AO 2.6 SP0.

Thanks,

Brian Aldrich

[former_member349978 · Accepted solution]

This was resolved by changing the ActiveX security in the Excel trust center settings. This might be a good sentence to include in the administration guide for AO.

[former_member186338 · Accepted solution]

Ups, disabling ActiveX controls at all is definitely not default setting 🙂

[panchomoreno10 · Accepted solution]

Gracias por tu valioso aporte, me has salvado, configure esta opción y todo bien en mi AO.

[Former Member]

I configured the address of the server in the trusted locations, in Active X configuration enabled without restriction, in Macros configuration I enabled all the macros and lastly in external content I enabled the connections to the database and it worked.

[Marc_Kuipers]

Hi Brian

This is the central note for EPM add-in security issues

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

Marc

[former_member349978]

I've seen that note. It has not been updated for Office365/Excel 2016. Thanks.

[former_member186338]

How do you setup AO? For single user or for all users of PC?

Test AO setup with the user with admin rights.

[former_member186338]

P.S. Why do you need AO? Are you using embedded model?

[former_member349978]

Hi Vadim-

We use AO for the combined BI and BPC functions. It is setup for all users by an admin user. We don't use the embedded model. We are using the EPM plug-in tabs within the Analysis Add-in. This was working until our Office365 installation of Excel 2016 ProPlus.

[former_member186338]

Sorry, try to run AO with admin user!