automatic epm login to another excel work book

[MaheshKosuri]

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

[gcybill · Accepted solution]

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:

[former_member186338 · Accepted solution]

Sorry, but what do you mean by this answer?

[MaheshKosuri · Accepted solution]

Hi Cybill,

Got you. Thanks a lot

[roslyn_rosalia3 · Accepted solution]

Thank you! Just want to add for those who need it, this article has more info on opening new instances in Excel.

https://www.sumproduct.com/thought/alternative-excel-in-an-instance

[peter_warren_uk]

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

[MaheshKosuri]

Thanks Vadim. will be back once I check.

[former_member186338]

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

[MaheshKosuri]

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

[former_member186338]

Sorry, but absolutely not clear what you are doing!

Try to explain once again!