Skip to Content
avatar image
Former Member

Offline mode blowwing up Excel formulas, Why?

Feb 20, 2017 at 05:51 PM | 227 Views

We use Office 2010 right now (moving to Office 2016) Using BPC v10 SP25

Worksheets with simple filtering macros were working with Offline Mode until recently in BPC. We have made no changes in BPC recently. If the worksheet is filtered and we select Offline Mode, some but not all of the formulas seem to blow up and give errors (EPMRetreiveData, EPMMemberDesc, etc.) ranging from #N/A, to just pulling in incorrect descriptions, pulling a description into a cell that was bringing back data before; etc.

EPM Add-In for Excel | offline
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 07, 2017 at 05:32 PM

    Final answer, system bug that won't let you move the drop down further. Works when you shift to EPMPane or move down divider so drop down box is all in same section

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Vadim Kalinin
    Feb 20, 2017 at 05:59 PM

    You have to create a simple test case and provide screenshot. Also - what about type of Offline mode you are using?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 20, 2017 at 06:45 PM

    Part 1:

    Screenshots:

    1. Unfiltered initial view

    1. Unfiltered, Offline Mode

    1. Filtered view, initial

    1. Filtered view, Offline Mode

    Part 2:

    User options as set (these are the same on both the Office 2010 machine and the Office 2016 machine.

    Add comment
    10|10000 characters needed characters exceeded