Skip to Content

Analysis Office, EPM Plug-in and Excel 2016

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 23 at 04:47 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04 at 08:26 PM

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

    Test AO setup with the user with admin rights.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12 at 05:09 PM

    Hi Brian

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

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

    Marc

    Add comment
    10|10000 characters needed characters exceeded