Skip to Content

automatic epm login to another excel work book

Hi

I have opened two separate excel sheets. I have logged into epm addin from one excel sheet . when i click on another excel sheet, it is getting refreshed and connecting to same epm connection. We are on EPM 10 SP33 patch1 build 10182

Any excel parameter do i need to update?

Mahesh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    Nov 23, 2018 at 06:21 AM

    Hi Mahesh,

    If you recently updated your Office to 2013/2016/2019, Excel would not behave the same way as the old Office version.

    In the newer Office version, you need to hold ALT while opening the new Excel application.

    It will show below popup:


    capture.png (9.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2018 at 08:01 PM

    Sorry, but absolutely not clear what you are doing!

    Try to explain once again!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2018 at 08:21 PM

    I have opened two excel sheets loaded with epm addin. I have logged into epm addin from one excel sheet. Another one automatically connecting to same connection. It was not like that earlier.

    regards

    mahesh

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2018 at 10:51 PM

    I don't have the described issues. Please check report connections.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 19, 2018 at 08:39 PM

    Thanks Vadim. will be back once I check.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 10, 2018 at 03:49 PM

    I am using 32 bit Office 365 Excel

    What I did was to create a new shortcut to launch Excel in the Target box I add the /X parameter

    "C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE" /X

    If I launch Excel using this (or just copy paste that into the Run box) I can run multiple instances of Excel - All called Book1 and I can connect each instance to a different BPC system

    hope it helps

    Peter

    Add comment
    10|10000 characters needed characters exceeded