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_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!