Skip to Content
avatar image
Former Member

EPM Addin Office 365 Plus workbook calculation

Dear experts,

We are using EPM addin with a customer having different MS Office versions like Office 2010, Office 365 Plus.

Users were opening Excel workbooks from a network folder and some sheets contain EVDRE reports and some sheets are usual excel sheets with formulas having lookup to those EV functions included sheets. Office 2010 users does not need to be authenticated, connected or even EPM addin installation is not necessary, they open excel file and if they do not touch EVDRE included worksheets no "#Error, no current connection." is written on formulas.

But in Office 365 Plus openning excel file without log on to system, or on users without EPM Addin installed at the beginning giving "#Error, no current connection." error. It seems like all workbook formulas are revaluated at the beginning.

We have asked Microsoft experts, their comment was this is not a behaviour of Excel but EPM addins preference in different office clients. We were using 25.3 EPM addin I wonder if anyone with different client version or even not installed EPM Addin, with Office 365 Plus see "#Error, no current connection."

Best Regards,

Ergin Ozturk

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 23, 2017 at 01:42 PM

    In general it's a bad idea to use EVDRE functions with BPC 10+

    Can be used only for some short period for migration of reports to EPM.

    Add comment
    10|10000 characters needed characters exceeded